CSV export Record delimiter
David Thompson
dthmpsn1 at uiuc.edu
Wed May 14 15:28:15 PDT 2008
>Hi,
>
>Can anyone tell me how to force Panorama to create a csv file with unix LF
>as the record delimiter rather than Mac CR? (or whatever it's using)
>
>Also, is it possible to use Text Export Templates in a procedure somehow?
>Or is it possible to use the export command and specify the first data in
>the procedure, also the record delimiter?
>
>What I need to do is create a csv for upload to a remote server. The csv
>must have field names in the first record (but of course my field names do
>not match what must be in the first record).
I would use an Export command in a procedure.
Export "FileName", ?(info("BOF"),"TheirField1,TheirField2,TheirField3"+lf(),"")
+YourField1+","+YourField2+","+YourField3+lf()
info("BOF") is true when the first record is being exported, so the
field names will be exported before the first record's data but not
for the other records. lf() is a custom function that generates a
line feed. It's the same as chr(10).
Dave
More information about the Qna
mailing list