length - 5.
-Matt
On Feb 16, 2004, at 4:02 PM, Bob Haroche wrote:
> 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]
