How do I de-concatenate a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have aquired a database that has City, State, and Zip all together in one
field and I want to de-concatenate the data into three separate fields. I
know that it is possible to do it in a query because I remember someone
telling me how to do it years ago. But now I can't recall. Anyone have the
answer?
 
Thanks so much for the help! This was great. I was afraid that I was doomed
to exporting the field into Excel as a comma delimited file to achieve three
separate fields and then importing back to Access and doing an update query.
Thanks again!
 
Back
Top