2 Replies Latest reply: Feb 1, 2012 4:38 AM by Aylin Bisiren RSS

    Seperate a field/column in a table

      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!