Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Holland
    Posts
    16

    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
    Location
    New York
    Posts
    160
    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
    and
    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
  •