Regex to switch words?

Question

I have long list of two string in every row, numerical string and alphanumerical string (that are of different length in every raw), that I want to change (switch) position:

010110,file_1.txt
0120100,file_11.txt

To have this:

file_1.txt,010110
file_11.txt,0120100

Second string also include dots and underscores, as in example above. I tried regex that I used before for similar task but it doesn't work, I tried in Notepad++ and Powergrep.

([^_]*),(.*)

Replace with:

\2_\1

Tried that regex (with variations) but didn't have result.

Why is there an underscore in your regex and replace strings? — Bohemian, Aug 13 '16 at 10:04

score 5 · Answer 1 · answered Aug 13 '16 at 09:49

5

I'd do:

Find what: ^([^,]+),(.+)$
Replace with: $2,$1
Replace all

answered Aug 13 '16 at 09:49

Toto

89,455
62
89
125

score 1 · Answer 2 · answered Aug 13 '16 at 10:02

1

Use a reluctant quantifier *?:

Find: ^(.*?),(.*)
Repl: $2,$1

.*? matches as little as possible.

answered Aug 13 '16 at 10:02

Bohemian

412,405
93
575
722

The second string doesn't appear to have commas in, so this shouldn't make any difference. – Rawling Aug 13 '16 at 10:43

Regex to switch words?

2 Answers2