Hi Folks



I need the wild card or whatever which needs to be find and replace as follows,

To find: AAA-BB-DASDARF or 080152YCK281 or ILL1-218-01-MM-C-D (please note that the finding value should come with any combination of letters, numbers and hyphens)

Replace with: ppvalue="whatever we found from the above value"

Please help me out on this?

Thanks
Ganesan. G

Any combination of letters and numbers without some reference as to where they start and stop is a bit of a stretch, but a search for

<[A-Z0-9-]{12,18}>
might work for you.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks for the help!! gmayor

Still some of the occurrences not found like as follows, (sorry if i missing on this)

14AS48MA-TN
15NUA98CA
SZFZ10L-TR
FZQ3975-5.0LTT

Also note that the above numbers are not any particular length (even if it is 8 digits numbers can be possible)

Please advise on this.

The wider you open the window, the more dirt comes in.

However in this case try

<[A-Z0-9.-]{8,18}>
You may however get some false positives. See http://www.gmayor.com/replace_using_wildcards.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Yes. I can tried this way too.

Anyway thanks for the help gmayor.