How to split a field with comma separator?

[sbutler]

I have an import field with "City,State". After import, I need to split City & State into 2 separate fields. Using the comma as a delimiter, I am not sure which function(s) to use. Thanks!

[transpower]

City = LeftWords(City_State ; 1)

State = RightWords(City_State ; 1)

[Lee Smith]

transpower

LeftWords for the city will not work for cities with more than one name such as: San Francisco

Use:

City

[sbutler]

Beautiful! Thanks!!!