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