CSV export issues
Jean-Pierre Radley
appl at jpr.com
Fri Jul 7 14:58:13 PDT 2017
Thanks for all the suggestions.
You cannot use the double-quote (chr("34") as an argument in filePro.
If you try
c=chr("34")
c comes back empty.
You can't use chr("34") in expressions for functions like INSTR, MID,
STRTOK, XLATE, oe MID.
But I still found a pot at the end of my rainbow, by changing
export word rpt=/usr/tmp/report.csv
to
export ascii rpt=/usr/tmp/report.csv r=\n f=,
That still leaves the trivial issue of editing strings containing
commas, but I now have a CSV file which contains output like
1-1/4" 2FL W/ 3/4" SH
3/4" 4FL SEEM CARB 7"OAL
--
JP
More information about the Filepro-list
mailing list