8 Replies Latest reply: Jul 26, 2015 11:44 PM by jagan mohan rao appala RSS

    Reading Digits from string

    Amir Panah

      Hi all, in my table i have a column which contains digit and string as below:

       

      IncomeValue-1Value-2
      1000RM to 2000RM

      Above RM3200

      3000
      RM1000 to RM 3000

       

      I need to read the digits, and store them in new columns, for example in first row, 1000 must be store in Value-1 and 2000 in Value-2,

      in second row, 3200 must be store in Value-1.

      It would be appreciated if anyone can help.

      Regards,

      Amir