You can check other example here:
Notepad++ regex replace capture group examples list
Notepad++ regex replace wildcard capture group
regex separate group of words from other values
- Open the file in Notepad++
- Replace CTRL + H
- Add quotes to words(two times for the last/first column):
- 1 Rome Italy - > 1@Rome Italy
- Find what - (\b\d+)\s(\u)
- Replace with - \1@\2
- Tokyo Japan 24 - > Tokyo Japan@24
- Find what - (\u|\l)\s(\d)
- Replace with - \1@\2
Before
1 Rome Italy 11.8% 2 210,404.4 111,951.9
2 Tokyo Japan 24.8% 0 312,366.2 114,654.8
After
1@Rome [email protected]% 2 210,404.4 111,951.9
2@Tokyo [email protected]% 0 312,366.2 114,654.8
find group of words
- Open the file in Notepad++
- Replace CTRL + H
- Add quotes to words(two times for the last/first column):
- Find only: "Seoul South Korea", "Guangzhou China", "Prague Czech Republic"
- Find what - ^\u[\w+\s]+\r\n
- Find what - \b\u[\w+\s]+[\r|\s]\b
Find group of capitalized words
9764
Seoul
South Korea
-1734$
6
9,159.1
13,229.7
17
Guangzhou
China
8,182.5
8,550.7
-14.9%
Prague
Czech Republic
8,182.5
8,550.7