Parsing mailmerge data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maureen - 03 Jun 2004 21:45 GMT

Hi all,

I have a mailmerge field that has a name in this format:

Smith, Bob

and I'd like to rearrange it to say "Bob Smith". Does anyone know a
(non-programmatic!) way to parse this field and get it the way I'd
like it?

Thanks for your help.

Reply to this Message

Doug Robbins - Word MVP - 03 Jun 2004 23:05 GMT

Hi Maureen,

Use a wildcard Edit Replace with

(<*>), (<*>)

in the "Find what:" control, and

\2 \1

in the "Replace with:" control

Note that there is a space after the comma and between the 2 and the \

See the article "Finding and replacing characters using wildcards" at:

http://word.mvps.org/FAQs/General/UsingWildcards.htm

It gives a very similar example.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thanks for your help.

Reply to this Message