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 / January 2004

Tip: Looking for answers? Try searching our database.

Manipulating strings returned in merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Harry - 22 Jan 2004 16:34 GMT
I am creating documents using merge fields and the output
of a program that I can't get rid of. The process is
automated so I can not edit the merge data before it is
included in the document. Names are formated either fn
mi. ln or ln/fn/mi  . I only want ln (it's not available
from the program.) Is there some way to manipulate the
string that is returned from the merge field?
Thanks for your assistance.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 08:54 GMT
Hi Harry,

You might be able to execute the merge to a catalog, or directory type main
document, then manipulate the data in that document before using it as the
basis for merging to your letter.

It is not clear whether the different formats that you mention are optional
or a mix over which you have no control.

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

>I am creating documents using merge fields and the output
> of a program that I can't get rid of. The process is
[quoted text clipped - 4 lines]
> string that is returned from the merge field?
> Thanks for your assistance.
Harry - 23 Jan 2004 14:08 GMT
Thanks, Doug.

I'm not sure what you meant in your answer, but I
understand the request for clarity.

I am using a program that keeps track of personal
information related to litigation. The program generates,
internally, a merge data file and performs the merge to
yield a document. I can define the merge document format,
but the program contains all the merge fields internally.
Thus, even though I input last name, first name and middle
initial in separate places on a form, the program only has
merge fields for output as regular text (firstname
middleinitial. lastname) or formatted text
(lastname/firstname/middleinitial).

To create a letter, I want to use the last name only. I
can edit the resulting document, but that's inelegant, and
adds to the cost of producing the document. I would like
to get a subset of the regular text string or formatted
text string that is placed into the document by the
program.

I figured out a way to do it in WordPerfect by adding
about a page of codes to the beginning of each master
document template. But, WordPerfect has many other issues
that make is less desireable to use than Word.

I'm not sure that what I want to do can be done in Word.
If not, that's ok, I'd just like to know for sure one way
or the other.

Thanks for your prompt response.
>-----Original Message-----
>Hi Harry,
[quoted text clipped - 16 lines]
>
>.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Jan 2004 01:04 GMT
Hi Harry,

If you choose the Lastname/FirstName/MiddleInitial format, then use a
Wildcard Edit>Replace with

([A-z']{2,})[/][A-z]{2,}[/][A-Z.]{1,}

in the find what control and

\1 in the replace with control, the Lastname/FirstName/MiddleInitial will be
replaced by only the Lastname.

See "Finding and replacing characters using wildcards" at:

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

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

> Thanks, Doug.
>
[quoted text clipped - 62 lines]
>>
>>.
 
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.