Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Split column based on conditions

Hi all I am trying to split a city column which is not consistant across all, some ends with a number and some doesn't. I am basically trying to split the city text and number into two different col...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - So given the below sample data, what is your desired output?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler , below is the desired output. I want get rid of the City ID wherever exists otherwise just display the text as City.

 

Desired Output
LA-VILLE PLATTE
CA-CITYOFIND-4040SCAP(US18)
MI-MUSKEGON-2076 NORTHWOODS DR
North Dallas (TX)
Denver - Colorado
CITYOFIND - A117 - CA