I have various tabe-delimited text files that contain data
with double quotes, such as 3" (meaning three inches).
If the number of double qoutes in the file is an odd
number (ie 3" 6" 9"), then my merge fails.
If number of double quotes in the file is an even number
(ie 3" 6"), the merge runs correctly.
Any ideas what causes this? Record delimiter is CRLF.
Thanks, Mike O.
Peter Jamieson - 10 Mar 2004 09:03 GMT
I think this was answered elsewhere, but in essence double-quote characters
are typically used to delimit text strings in "text data sources", so
software that is trying to recognise the records and fields in your text
file frequently gets confused if you use them for other things. Typically,
you will have to preprocess your file, probably so that each " used for
"inches" is doubled up. However even that may not be enough.

Signature
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/
> I have various tabe-delimited text files that contain data
> with double quotes, such as 3" (meaning three inches).
[quoted text clipped - 8 lines]
>
> Thanks, Mike O.