Hi Team,
Hope your well.
I need some help,
For a particular sub set of countries (United States, Australia, Canada) i would like to produce a new column which extracts the State ISO
Country : Country ISO
Country2 : Country Name
State/Province : CountryISO + State ISO
Example Data
Country | Country2 | State/Province |
AU | Australia | AUNSW |
AU | Australia | AUVIC |
AU | Australia | AUWA |
CA | Canada | CAON |
US | United States | USOH |
US | United States | USOR |
Expected Outcome
Country | Country2 | State/Province | State/Province ISO |
AU | Australia | AUNSW | NSW |
AU | Australia | AUVIC | VIC |
AU | Australia | AUWA | WA |
CA | Canada | CAON | ON |
US | United States | USOH | OH |
US | United States | USOR | OR |
Looking forward to your help
Regards
Masond3
Solved! Go to Solution.
Hi @Masond3
There are various ways of doing this -
If you are always going to have that country column you could try this - replace([State/Province],[Country],"")
Or if not this would work - Substring([State/Province],2,3)
Regards,
Ben
Hey
Thank you so much for your input. its simple but effective 🙂
Have a great Day