Seperate a field/column in a table

[#1]

Hello,

i need some help. My problem is:

i have a field/colum names TEST that contains for example:

A 1s

A 1r

A  12s

A 12r

I want now a table, that contains A, 1 or 12, r/s as columns.

I tried left(TEST,1) as column1,

mid(TEST,3,1) as column2,

right(TEST,1) as column3.

My problem is now, that the value 12 in column is showed as 1 because of mid(TEST,3,1).

How can i change the function to show the value 12?

Thank you for your help!

[CELAMBARASAN · Accepted solution]

Hi,

     For that use this expression

          mid(TEST,3,len(TEST)-3)

Celambarasan

[#3]

Thank you very much! It works!