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.

    9a6b24de-d148-4369-a6e9-19939b4d5092-image.png

    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