Unconcatenating a Field into several Fields

Topic

New Reply

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…

Reply | Quote

Replies

Look into using Left, Mid, and Right functions

Reply | Quote

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.

Reply | Quote

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!!!

Reply | Quote