Trying to create a module that loops throw a record set to split a field in a table

[sam77755]

Hi

I inherited a table where 2 fields are merged together into 1.
currently the field looks like this: 115586010/20/2002
and I would like to split it into 2 fields I.E field1 1155860 field2 10/20/2002.
I know this must be a commun questions but i searched all over for an answer but could not find it.

Can antone please help
thank you

 

[sam77755]

Forgot to mention that the first field size is always 9 charachters and the second is always a date format.

 

[KenHigg]

Q. Would a date say like Jan 15, 2005, be represented like 01/15/2005 or would it be 1/15/2005?

kh

 

[KenHigg]

You should be able to use a left(), right() or mid() function to split these out...


kh

 

[sam77755]

it would be 1/15/2005

 

[KenHigg]

I would add two new flds to the table. Named something like myNewDate and myNewNumber.

Then do a update query and fo the myNewNumber fld, use something like this:

left(myOldFieldName, 9)

and for the myNewDate fld:

right(myOldFieldName, len(myOldFieldName)-9)

???
kh

 

[sam77755]

thank you Ken will try this an let you know... cheers

 

[sam77755]

Worked Great
thanks alot