UNIX format CSV File read into Jade

[ConvertFromOldNGs]

by Scott Sheng >> Fri, 23 Dec 2005 12:12:56 GMT

The CSV file pull out from Sun Solarios OS, its file format is UNIX and cannot be read into Jade system correctly, it is imported to be as one line in Jade. But if you save it to be as PC file format, then it can be read into one by one line. My work space for it is below.

vars
file:File;
s:String;begin

create file transient;
file.fileName:="C:\T20051223000000.csv";
while not file.endOfFile()
do
s:=file.readLine();
write s;
endwhile;
epilog
delete file;
end;

I'd appreciate if someone could help me this.

Thanks
Scott

[ConvertFromOldNGs]

by Murray Symon >> Fri, 23 Dec 2005 21:17:47 GMT

Unix has a different line terminator (Lf) from PC/Windows (CrLf).
Jade sets the default according to the platform it is running on.
You can re-define it on the File object as follows (before the while loop):

file.endOfLine := Lf;

--
HTH,
Murray Symon.