5 Replies Latest reply: Jan 2, 2017 10:30 AM by Philippe NICOLAS RSS

    STRING 254 01:58

    Fabio Mazzarelli

      Hi Community,

      i have this values

      NUMBER

      250 07:03

      670 09:30

      28 15:01

       

      if i use

      left(NUMBER,3)

      mid(NUMBER, 5,2)

       

      result is

      left

      250

      670

      28

       

      mid

      07

      09

      5 (error)

       

      How could I extract the 3 (left) characters having a dynamic field ?