Export TransferText with quotes in text

  • Thread starter Thread starter css
  • Start date Start date
C

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
 
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
 
Back
Top