Re: Splitting Access DB Columns

[brobborb]

manually create a new table with the fields city and zip.  Uses coldfusion to read the file your client gave you, and parse it through a loop.  do a list loop, with the delimeter being #chr(13)# (which is the return char.  Then through each interval, extract the last 5 characters from the index, and append it to some variable A.  Then, do a function to extract the first parts of the list minus 5.  That way u will get the city, minus the zip code.  Append it to vairable B.  Now you have them in separate lists.  The only thing left to do is to insert those into the tables u made :-D

  ----- Original Message -----
  From: Bob Haroche
  To: CF-Talk
  Sent: Monday, February 16, 2004 3:02 PM
  Subject: SOT: Splitting Access DB Columns

  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]

---