I have a file with a some comma separated names and some comma separated account numbers. So the names will always be something like "Dow, John" and the numbers like "012394,19862". Using Notepad++'s Regex Find features, I'd like to change all the ','s between the numbers into '|'s.
Basically turn:
12345,09876
13568,08642
into
12345|09876
13568|08642
I've been using [0-9],
to find the commas, but I can't get it to properly leave the last digit of the number and replace just the comma.
Any ideas?
Search for
([0-9]),
and replace it with\1|
. Does that work?use this regex
and replace it with
OR
(?<=\d),
should work. Oddly enough, this is only working if I use replace all, but not if I use replace single. As an alternative, you can use(\d),
and replace with$1|