CSV files

CSV files

We are running JD Edwards version 7.3.3.
I have produced a report using the report writer, which is to output a CSV file for input into an analysis package. When the CSV file is produced, each record has the line feed (X'0A') as the delimiter, not the carriage return/line feed (X'0D0A').

Does anyone know how to force JD Edwards to output the CRLF as a record delimiter?

Many Thanks

Martin

Re: CSV files

JDE uses the platform-native line termination - so I'd guess you run this on UNIX? On NT local, I certainly get CRLF.

If on UNIX,
cat test.csv | awk '{print $0"\015"}' > testnew.csv
should do the trick.