need help with string functions

[vz]

hi,
I have a field with test numbers. Test numbers are 6 characters long, but in some cases I have more than one test number in the field so it ends up looking like this 123456123456123456. In that situation I have 3 test numbers and it would be easy for me to do the left, mid and right functions, but my problem is I don't know how many tests I am going to have in that field, sometimes I might have 1, or 3 or even 6 test numbers. Is there a way for me to split one record into multiple records depending on the number of test codes? I basically want 1 test code per record.
Thanks in advance

 

[Bastien]

why not split the item into an array. you know the length of your number is 6 digits....and you can find the max length of the number....divide the two and you have the number of elements in the array and you can test each one

hth

bastien Bastien

There are many ways to skin this cat,
but it still tastes like chicken