Community
    • Login

    Separator

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    5 Posts 2 Posters 442 Views
    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.
    • Mario CastroM
      Mario Castro
      last edited by

      Good morning,

      Guys I do have a question, I have these numbers in note ++

      Mario|123456789|dfsdf
      Maria|987654321|dfsdfs
      Robert|156824322|fsdfsdf

      I need to place a dash in between the numbers like this

      Mario|123-45-6789|dfsdf

      And then copy the format for the rest, could you please help me out?

      Alan KilbornA 1 Reply Last reply Reply Quote 0
      • Alan KilbornA
        Alan Kilborn @Mario Castro
        last edited by Alan Kilborn

        @Mario-Castro

        Try:

        Find: ^(.+?\|\d{3})(\d{2})
        Replace: ${1}-${2}-
        Search mode: Regular expression
        (untested, should work)

        Learn more HERE.

        Mario CastroM 1 Reply Last reply Reply Quote 2
        • Mario CastroM
          Mario Castro @Alan Kilborn
          last edited by

          @Alan-Kilborn

          Hey Alan

          Thanks for the response.

          Allan, I just performed the update in the file, but the thing is that I need to apply it in at least 200 thousand more, so I would like to know, what would be the correct order?

          15348|15348|1534|123456789|Mario ABC|store
          871451|871451|1534|987654321|Maria ABC|store
          1245314|1245314|15348|156824322|Robert ABC|store

          I need a way to add the dash no matter how many numbers the column has at the beginning

          15348|15348|1534|123-45-6789|Mario ABC|store
          871451|871451|1534|987-65-4321|Maria ABC|store
          1245314|1245314|15348|156-82-4322|Robert ABC|store

          Alan KilbornA 1 Reply Last reply Reply Quote 0
          • Alan KilbornA
            Alan Kilborn @Mario Castro
            last edited by Alan Kilborn

            @Mario-Castro

            I need a way to add the dash no matter how many numbers the column has at the beginning

            Try this instead:

            Find: (?-s)^(.+\|\d{3})(\d{2})

            1 Reply Last reply Reply Quote 2
            • Mario CastroM
              Mario Castro
              last edited by

              Thanks Alan

              You rock!

              1 Reply Last reply Reply Quote 1
              • First post
                Last post
              The Community of users of the Notepad++ text editor.
              Powered by NodeBB | Contributors