I have a column which captures the email subject. All items have the same email subject followed by the relevant/unique country name:
The country in the email subject makes the email unique. I need to pull the country out into a country column to allow filtering on the country.
;\w+ works for countries with one word but I need a pattern that will work for single or multiple words in the country name.
For example - using ;\w+ for Spain works but for Saudi Arabia it only picks up the Saudi.