My client gave me a copy of their "database" which has a field for
city, containing both city and zip code, eg:

New York 10021
Santa Rosa 95404

Within the DB I need to split this column into two, one for city and
the other for zip.

How can I do this using Access 2002 and/or ColdFusion and regexp.

Thanks in advance.

-------------
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to