Hi all - I have address data that includes both the city name and zip code. The zip code contains five to seven alphanumeric characters. The city names may contain multiple words. I would like to parse the column into two columns for city and zip code. Thanks in advance!
The data looks like this:
ADDRESS |
LONDON EC1Y 2AB |
EAST MORTON |
NW7 4SD LONDON |
HAMPSHIRE |
ROMFORD RM3 8FU |
SEVEN OAKS TN13 1JG |
TN13 1JG |
I would like the output to look like this:
ADDRESS | CITY | ZIP |
LONDON EC1Y 2AB | LONDON | EC1Y 2AB |
EAST MORTON | EAST MORTON | |
NW7 4SD LONDON | LONDON | NW7 4SD |
HAMPSHIRE | HAMPSHIRE | |
ROMFORD RM3 8FU | ROMFORD | RM3 8FU |
SEVEN OAKS TN13 1JG | SEVEN OAKS | TN13 1JG |
TN13 1JG | TN13 1JG |
Solved! Go to Solution.