CSV export Record delimiter

[C.W. Frymire]

Thanks Dave!  That's gonna work great!
 
CW Frymire
Vice President, Operations
Red House Records, Inc.
operations at redhouserecords.com

                                         



> From: David Thompson <dthmpsn1 at uiuc.edu>
> Reply-To: "Panorama Questions & Answers (Discussion)" <qna at provue.com>
> Date: Wed, 14 May 2008 17:28:15 -0500
> To: "Panorama Questions & Answers (Discussion)" <qna at provue.com>
> Subject: Re: CSV export Record delimiter
> 
>> 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
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna