Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2004

Tip: Looking for answers? Try searching our database.

Datasets containing uneven double quotes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike O. - 04 Mar 2004 15:22 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.