Re: concatenate and parse merged field with text

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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.

--
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

"Joseph" <Joseph@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29226989-CA2C-418C-B2C3-6EFDEFA60B3D@xxxxxxxxxxxxxxxx
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?


.



Relevant Pages

  • Re: Word Mail-merge to email looses BG Color on Web-Based Mail
    ... You can only control your end of it. ... What the recipient does, or what their ... Doug Robbins - Word MVP ... If you are using Office XP or later, the "Add-in to Merge Letters to ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Option buttons not working
    ... Word MVP web site http://word.mvps.org ... Stefan Blom wrote: ... an option button control that is not ActiveX. ... option groups, and the other with all check boxes. ...
    (microsoft.public.word.docmanagement)
  • New LottoGenius version - comments please.
    ... limit an amount of numbers inside any decade. ... Final Digits: matching final digits (all digits count, ... control the low/high numbers ratio within a combination. ... Sums: range of sums (selected numbers within the combination ...
    (rec.gambling.lottery)
  • Re: Userfrom "Control Tab Order based on input"
    ... finally, depending on the test result, the focus of the next control will be ... Update events are iffy in such a case if users tab right out without making ... So you pretty much have to go the Exit event road... ... Jean-Guy Marcil - Word MVP ...
    (microsoft.public.word.vba.userforms)
  • Re: Form Field/Codes
    ... see Word MVP FAQ - Userforms ... Word MVP web site http://word.mvps.org ... putting only 5 digits in. ... the windows pop up for them to put the ...
    (microsoft.public.word.docmanagement)