Export arguments to handle "," in a record?
Mike Schwartz-PC Support & Services
mschw at athenet.net
Wed Jan 19 10:47:13 PST 2005
> Matt sez:
> My export arguments right now are -r=\n -f=, which is pretty standard.
>
> However I came across a field that had the following contents: 584
> LTD,84"oak
> Therefore when outputted it looks like: ,"584 LTD,84"oak", - a nightmare.
If you want to keep the standard commas between fields, I would suggest
using xlate to strip out the double quotes. For example, if you are moving
field 1 to export field 1, use a line like:
outfile(1)=xlate(1,chr("34"),"'")
This will change all the double quotes to single quotes in your export file,
and the file will read in to other programs like Excel, without any other
manipulation required.
Mike Schwartz
More information about the Filepro-list
mailing list