Notepad++ regex find group of words and replace

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

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

[email protected] [email protected]% 2 210,404.4 111,951.9
[email protected] [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
Share Tweet Send
0 Comments
Loading...