CSV export issues

[Fairlight]

Why not just use open() and writeline(), the way God intended?  :)

You're going to have to do something to sanitise the quotes in your data
either way, though.

m->

On Sat, Jul 01, 2017 at 04:44:10PM -0400, Jean-Pierre Radley via Filepro-list thus spoke:
> I am trying to generate a spreadsheet using
> 
> 	export word rpt= /usr/tmp/report.csv
> 
> The filePro file is an inventory of metal parts. In the Description
> field the single or double quote may show up as the conventional
> abbreviation for feet or inches, e.g.:
> 
>         6" DIAL CALIPER WHITE FACE
> 
> Whenever this happens, processing goes nuts at the quote-mark: all the
> fields of every record up to the next one with a quote-mark are output
> on the same line of the CSV file.  If there are over 600 records between
> two fP records with a quote mark, the CSV file will have a line with
> over 600 columns.
> 
> I can of course use an edit to remove the quote-marks, but is there some
> way to use some escape mechanism to preserve them in the CSV?
> 
> Another minor annoyance:  I wanted to define the output file from data
> in the filePro input. Say field 1 is the customer number:
> 
> 	f = 1 { "-" { @td; export word rpt=f
> or
> 	f = 1 { "-" { @td; export word rpt=(f)
> 
> Neither works.
> 
> -- 
> JP
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 

-- 
Audio panton, cogito singularis.