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 / April 2005

Tip: Looking for answers? Try searching our database.

Header Record Delimiters fails . . .

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ward - 29 Mar 2005 16:49 GMT
to recognize my field delimiter and record delmiter.  The field delimiter is
a double quote and the record delimiter is the paragraph mark.  However, the
dropdowns for both fields do not give me the option to select either of these
field delimiters?  The preview pane shows the the fields in double quotes
with a paragaph marker at the end of each entry.  How do I fix this problem?  
Thanks.
Signature

Regards,

Ward

Peter Jamieson - 29 Mar 2005 20:55 GMT
If you really mean that " is the field delimiter, e.g. you have a file like

field1name"field2name"field3name
record1"Peter"blah blah
record2"Jamieson"blah blah

then I do not think you will succeed because as far as I know you cannot
choose " as the field delimiter whether you connect to the data using Word's
converter (which asks for the field and record delimiters), ODBC or OLEDB.
As far as I know there is a built-in assumption in all three methods that "
is, if anything, a "text delimiter".

So I think you will have to change that. IMO a tab character is often the
best option - even if you have tabs in your data, you can surroung the
fields by "" and you should be OK. Not completely straightforward if you
want to use ODBC though.Tilde ~ is sometimes a good choice too.

As for the paragraph mark record delimiter, typically Word will recognise it
correctly but in its dialog box it will probably preselect (enter) for you.
ODBC only recognises "enter" (i.e. CRLF in MSDOS/Windows systems, although
it might recognise CR alone or other combinations - I'm not sure). I think
OLEDB is the same.

If you are using a separate header record it's usually best to double up the
header line.

Peter Jamieson
> to recognize my field delimiter and record delmiter.  The field delimiter
> is
[quoted text clipped - 6 lines]
> problem?
> Thanks.
Cindy M  -WordMVP- - 29 Mar 2005 21:50 GMT
Hi =?Utf-8?B?V2FyZA==?=,

> to recognize my field delimiter and record delmiter.  The field delimiter is
> a double quote and the record delimiter is the paragraph mark.  However, the
> dropdowns for both fields do not give me the option to select either of these
> field delimiters?  The preview pane shows the the fields in double quotes
> with a paragaph marker at the end of each entry.

Because doublequotes are often used to designate that what is between them is
the literal field content (in case it would contain, for example, a paragraph
mark), I'm not surprised that doublequotes aren't allowed as field delimiters.
Try a TAB, a semi-colon or a comma.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Ward - 06 Apr 2005 17:33 GMT
The problem was with the merged document itself.  I opened my Word template
and pressed Alt-F9 and removed the double quotes surrounding the merged
fields.  This fixed the problem.
 
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.