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