Export TransferText with quotes in text

[css]

I've set up a TransferText to export data to a text file, which I import into
Word & can merge & print a template. Works great, until I discovered some of
my data has quote marks for inches (4" for 4 inches).

I need to keep the " after the 4. The table I'm exporting contains the
following:
dept (integer)=70
cat (integer)=57
item (integer)=289
desc (text)=TRASH PUMP 4" DIESEL TOWABLE

When I export to a text file, it shows the following:
"dept" "cat" "item" "CatDesc"
70 57 289 "TRASH PUMP 4\" DIESEL TOWABLE "

How can I change my export so it'll work correct? I've tried setting the
text qualifier to None, but then the Word merge failed.

Any help would be appreciated.

Connie

 

[GeoffG]

Using your present technique, you could use a delimiter that
doesn't appear in any field, a $ perhaps.

But wouldn't you be better off exporting to an rtf file? I seem
to recall Word will do a merge directly with an rtf file, which I
think gets formatted as a Word table.

Geoff

 

[css]

Thanks, Geoff! I knew there had to be a way to do it!
Connie