How to separate a column which has a comma separated values, into 2 different values?

Hello, Who knows how to separate this column into the name of the city and state (comma-separated value)? and then I need to add this new column to my current table, so I would love to know, thanks in advance!

Answer 1

[Voss]

city = ["Abilene, TX"; "Waco, TX"; "Arcata/Eureka, CA"];
t = table(city)

t = 3×1 table
           city        
    ___________________

    "Abilene, TX"      
    "Waco, TX"         
    "Arcata/Eureka, CA"

city_state = split(t.city,", ");
t.city = city_state(:,1);
t.state = city_state(:,2);

t

t = 3×2 table
         city          state
    _______________    _____

    "Abilene"          "TX" 
    "Waco"             "TX" 
    "Arcata/Eureka"    "CA"