Wildcard Search and Replace

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

  • @Andrew-0 ,

    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:

  • Holy Snikies!

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

Log in to reply