Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Wildcard Search and Replace

    General Discussion
    2
    3
    79
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Andrew 0
      Andrew 0 last edited by

      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.

      PeterJones 1 Reply Last reply Reply Quote 1
      • PeterJones
        PeterJones @Andrew 0 last edited by PeterJones

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

        • official NPP Searching / Regex docs
        • the forum’s Regular Expression FAQ.
        1 Reply Last reply Reply Quote 2
        • Andrew 0
          Andrew 0 last edited by

          Holy Snikies!

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

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright © 2014 NodeBB Forums | Contributors