Regex search to find and replace multiple strings
In order to find and replace multiple strings using regular expression you can use this format:
Find: (FindA)|(FindB)|(FindC)...
Replace: (?1ReplaceA)(?2ReplaceB)(?3ReplaceC)...
However if the operation is run this way it will not take word boundaries into consideration and will replace strings you search for which appear in the middle of other words. So if you run a search like this to capitalize the first names in a list of addresses:
. . .the search will not only capitalize 'Beth' but will also capitalize the string 'beth' in 'ElizaBeth'.
To prevent strings which are not words from being altered by the regex search use word boundaries around the searched for terms:
(\bbeth\b)|(\bmelissa\b)|(\bsusan\b)|(\bjennifer\b)
Comments