Databases
StackOverflow2013
Postsdbo
POWrite out a text file on Linux to be imported by Windows application, line break issues
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWrite out a text file on Linux to be imported by Windows application, line break issues
    primarykey
    data
    text
    <p>I've read a lot of stuff both on stackoverflow and around the net, I've also tried a dozen variations in my code &amp; am yet to find a solution. The method has to write out a text file according to these file specs I was given, so that another application on a windows based system can import the file. Have discovered a test for this is that if the line breaks look correct in notepad then the import succeeds.</p> <p>After the file is written to the server, it is then read again passed into a byte array that is later on attached to an email etc. (not sure it this would be relevant) </p> <p>I started with the higher level classes I usually use to write out files, and as I read more on the subject, tried using FileOutputStream so I could specify the CRLF bytes explicitly. (Still doesn't align correctly in notepad which is the test I'm using)</p> <pre><code>byte[] CRLF = { 0x0D, 0x0D, 0x0A };//"If you write \r\n on Windows, you'll actually get 0x0D 0x0D 0x0A in the file" Map&lt;String, ByteBuffer&gt; fileMap = new HashMap&lt;String, ByteBuffer&gt;(); //eg: BA20110627-2.TXT Timestamp nowTimestamp = UtilDateTime.nowTimestamp(); DateFormat df = new SimpleDateFormat("yyyyMMdd"); String date = df.format(nowTimestamp); int count = 1; for(Map&lt;String, List&lt;String&gt;&gt; fileLineListsAndTotAmountMap : fileLineListsAndTotAmountMaps){ String fileName = "BA"+date+"-"+count+".TXT"; FileOutputStream out = new FileOutputStream(fileStorePath+fileName); String header = ""+new Header(date).toString(); byte[] headerAsBytes = header.getBytes(); out.write(headerAsBytes); out.write(CRLF); //each map only has one entry Map.Entry&lt;String, List&lt;String&gt;&gt; entry = (Entry&lt;String, List&lt;String&gt;&gt;) fileLineListsAndTotAmountMap.entrySet().toArray()[0]; for(String s: entry.getValue()){ if (!s.equals("")) { String line = s; byte[] lineAsBytes = line.getBytes(); out.write(lineAsBytes); out.write(CRLF); } } //totNumOfDebitRecords, totAmountForDebitRecords String footer = ""+new Footer(new Integer(fileLineListsAndTotAmountMap.size()).toString(), entry.getKey()); byte[] footerAsBytes = footer.getBytes(); out.write(footerAsBytes); out.write(CRLF); out.flush(); out.close(); fileMap.put(fileName, ByteBuffer.wrap(getBytesFromFile(new File(fileStorePath+fileName)))); } </code></pre> <p>The only other thing I can think of trying is using maybe java.nio.charset.CharsetEncoder &amp; trying to encode it as ASCII though I can't really see how that would help.</p> <p>Can anyone shed a little more light on this sort of issue?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USjustify
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIf you are writing text, why aren't you using FileWriter instead of OutputStream?
      singulars
      1. POWrite out a text file on Linux to be imported by Windows application, line break issues
      1. USMaurício Linhares
    2. COMy first pass used `new BufferedWriter(new FileWriter())` & `out.write(line + "\r\n");` "I started with the higher level classes..." it didn't work
      singulars
      1. POWrite out a text file on Linux to be imported by Windows application, line break issues
      1. USjustify
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload