parsing data from textfield

[BubBob]

I need to separate values from a single textfield -> prm1prm2prm3 will be prm1, prm2, prm3. How is it done? I'm stuck in this relatively simple question.

 

[liddlem]

have you tried using
left(prm1,x)
mid(prm2,x,y,z)
Right(prm3,x)

where
"x" = length of the string that you want returned and
"y" = starting point where prm2 starts and
"z" = number of characters to return.

 

[jtvcs]

If this is a one-time need and the data in the 'combined field' is not fixed length for each smaller field, you may want to export the data to Excel, do the parsing there then import the finished result into its three fields in the database. Excel has a parsing facility. Just an alternate suggerstion. HTH JT