concatenate and parse merged field with text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joseph - 27 Nov 2006 19:23 GMT

I need to concatenate the ID from our system into an ID our users use for web
access. The ID in our system is an 11 digit number. The web access ID is the
last 7 digits of that number with a "W" in front.

The extract we get to merge the ID info only contains the system ID. To
derive the web access ID, we need to concatenate a "W" with the last 7 digits
of the system ID. I thought this would be easy to do using Word logic, but
several of us have tried with no luck. We don't want to go to Excel first, as
that adds an extra step our business process.

Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 27 Nov 2006 20:50 GMT

I think that the only way that you could do this would be to use a Wildcard
replace after executing the merge with

([0-9]{3})([0-9]{8})

in the Find what control and

W\2

in the replace with control.

Signature

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

>I need to concatenate the ID from our system into an ID our users use for
>web
[quoted text clipped - 11 lines]
>
> Any ideas?

Reply to this Message

Joseph - 27 Nov 2006 21:09 GMT

Thanks Doug. I was fiddling around with a Word macro, trying to automate the
entire process and your suggestion put us on the right track. Instead of
trying to parse and concatenate each ID as it looped through the merge
process, we inserted find and replace code after the merge. Worked
beautifully, and no extra work necessary!!

> I think that the only way that you could do this would be to use a Wildcard
> replace after executing the merge with
[quoted text clipped - 22 lines]
> >
> > Any ideas?

Reply to this Message