Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    Unanswered: Splitting up zipcode

    I have an access db with a column zipcode I want to split up:

    3022 EB

    Now I would like to create 2 separate colums. 1 will have the first 4 digits and the 2nd column will get the last 2 letters.

    It is always 4 digits and 2 letters with.

    How can I split them?

  2. #2
    Join Date
    Jan 2003
    New York
    use the split function - which will create an array

    when you wrote
    3022 EB -- is there a space or did you display that for easy reading
    if there is a space then do the following

    NewZip = split(zipcode)
    By doing this it splits zipcode by space,
    NewZip(0) will equal 3022
    NewZip(1) will equal EB

    else if there is no space and you know you want first four chars then
    NewZip4 = left(zipcode,4)
    NewZip2 = right(zipcode,2)
    Beyond Limitation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts