Wildcard Search and Replace

Andrew 0

Hello.

I am trying to find any field that is 16 digits long that starts with 123456 and replace it with 123456XXXXXXXXXX.

Here is a snapshot of what I am trying to accomplish.

I tried 123456.*, but it replaced everything to the right of that field. I just need that specific field updated.

Any assistance you could provide would be appreciated. Thanks.

PeterJones

Very close. The * quantifier means “0 or more”. What you want is a quantifier that gives an exact number of digits… in this case, 123456.{10}, which says “123456 followed by exactly 10 other characters”.

You might change it to 123456\d{10}, which says “123456 followed by exactly 10 numerical digits”.

----
Regex Docs:

official NPP Searching / Regex docs
the forum’s Regular Expression FAQ.

Andrew 0

Holy Snikies!

Thank you so much. I have been searching high and low for that solution. Appreciate it!