Export arguments to handle "," in a record?
Matthew Williams
matthew.d.williams at gmail.com
Wed Jan 19 09:06:13 PST 2005
As many of you have seen I am exporting a bunch of invoice files. I
have setup a Word file with a merge so everything looks nice and
pretty and then can be e-mailed out. However I have come across some
records that are a bit fussy.
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.
When I attempt to merge that in my word file it chokes as you could
imagine. What would be the easiest work around? If I change the
field delimiter to something that would never show up in a field work?
Or is there a way to put quotes around any commas inside a field
which is what I thought it would do on its own.
Thanks!
-Matt
Hale Mfg.
More information about the Filepro-list
mailing list