Separating Text

K

ktfrubel

I have a table, that imported a City, State Zip Field.
Is there a query that can be run to separate all of these in to their own
fields?
 
D

Dale Fye

Not easily.

If every record is is formated similar to:

City Name, State zip
New York, NY 12345

Then you could use:
City: Left([FieldName], instr([FieldName], ",") - 1)

State = Mid([FieldName], instr([FieldName], ",") + 1, 2)

Zip = Mid([FieldName], instrrev([FieldName], " ")+1)

HTH
Dale
 
Top