Separator

Mario Castro

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 Kilborn

@Mario-Castro

Try:

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

Learn more HERE.

Mario Castro

@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 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})

Mario Castro

Thanks Alan

You rock!