Can you remove words from a mergefield using field codes?

[ZeonAutonomy]

We have a wrod document which we merge a field from our database too. The
database outputs "First name Middle name Surname" we would like our letters
to say "Dear Paul" rather than "Dear Paul Jon Humphries". I've been looking
for a merge field code which could be used to purely pull through the first
word, but have been unsucessful. Can anyone help/advise?

 

[Doug Robbins - Word MVP]

You will have to separate the data in the data source to achieve what you
are after.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Cindy M.]

Hi =?Utf-8?B?WmVvbkF1dG9ub215?=,

We have a wrod document which we merge a field from our database too. The
database outputs "First name Middle name Surname" we would like our letters
to say "Dear Paul" rather than "Dear Paul Jon Humphries". I've been looking
for a merge field code which could be used to purely pull through the first
word, but have been unsucessful. Can anyone help/advise?

Word doesn't provide any facility for manipulating text. It's not possible to
pull out a single word, or a number of characters, or anything of that nature.

The best thing to do would be to redesign the database.

The other possibility - if the database supports it (unfortunately you don't
mention what kind of database this is) - would be to run a query in the
database that pre-processes the information before passing it to Word.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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