sbutler Posted January 7, 2005 Posted January 7, 2005 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 Posted January 7, 2005 Posted January 7, 2005 City = LeftWords(City_State ; 1) State = RightWords(City_State ; 1)
Lee Smith Posted January 7, 2005 Posted January 7, 2005 transpower LeftWords for the city will not work for cities with more than one name such as: San Francisco Use: City
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now