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