CSV export issues

Jean-Pierre Radley appl at jpr.com
Mon Jul 10 15:34:10 PDT 2017


Brian K. White averred (on Mon, Jul 10, 2017 at 03:11:05PM -0400):
| 
| 
| -----Original Message-----
| From: "Jean-Pierre Radley via Filepro-list" <filepro-list at lists.celestial.com>
| Sent: Friday, July 7, 2017 5:58pm
| To: "filePro Mailing List" <filepro-list at lists.celestial.com>
| Subject: Re: CSV export issues
| 
| 
| 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
| 
| ------------------
| 
| 
| Perhaps c = "\"" would have worked, I was just trying to play it safe because I don't *think* that would work, and, store the value to use it a zillion times rather than running a function to generate it a zillion times.
| 
| I am not in a position to double check myself directly right now, but I am very skeptical that you can't  c = chr()  ?? really??? I could *swear* we've done that countless times for backslash (97 I think?) and other chars.
| 
| I will have the take your word for it for now I guess, and It's good you got around it anyway.
| 
| -- 
| bkw

You can succeed with c=chr(NUM) for many values of NUM, but 34 isn't one of
them.

-- 
JP


More information about the Filepro-list mailing list