Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unconcatenating a Field into several Fields

    How do I take the contents of a Field

    example: Text Field
    Employee ID NA1A010201

    Where the amount of numbers and text are equal in every record (10), and divide this field into 3 seperate fields? The First field would be NA
    The Second field would be 1A
    And the Third field would be the date 010201

    Any help would be ever so appreciated...

    <img src=/S/help.gif border=0 alt=help width=23 height=15>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unconcatenating a Field into several Fields

    Look into using Left, Mid, and Right functions

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unconcatenating a Field into several Fields

    I'm assuming that Employee ID is the name of the field and not part of the value in the field.

    Use the MID, RIGHT AND LEFT Functions to parse the field into three separate fields by using a query based on the table and creating three new fields as expressions.

    MID([EmployeeID],3,2) GIVES YOU 1A

    RIGHT([EmployeeID],6) gives you 010201

    LEFT([EmployeeID],2) gives you NA

    Hope this helps.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unconcatenating a Field into several Fields

    PrestonK & BCKessinger,

    Thanks for your help. It was so much help to me. It worked perfectly. BCKessinger, your method was in the direction I had to go, but PrestonK, thanks for (do you have ESP) knowing that I may not know how to set it upcorrectly, and giving me such example and detail. You are SUPER!!!
    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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