Hello there,
I have a table that was created by pulling in an Excel file. The issue is that there is that City, State, Zip, and County are....in one field. How can I break up the string so it is 4 fields respectively?
Thanks
The key is to find patterns on which to break out the string into its components. If this for US addresses only, the State should always be 2 characters, the zip should always be numeric...
HTH
John
Use what you have,
Learn what you can,
Create what you need.
I have some City State Zip and some Zip+4 the format is:
ALLEN PARK MI 48101 (no commas)
and
ALLEN PARK MI 48101-1012 (no commas)
I only want the City (ALLEN PARK) portion how do I do this without counting from the left or right for many Cities in my dbf are different in length and also have space some don't? Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.