1 Reply Latest reply: Aug 25, 2017 12:48 PM by Carlos Silva RSS

    Identify String or text and eliminate the zeros at the beginning of string

    Xiaoyu Yang

      Hello Guys,

       

      I need to load "material number" from original file as:

      00002532548452,

      0000000698542,

      A7B765430,

      P PPXX,

      78BL333

       

      I want to have results shown as:

      2532548452,

      698542,

      A7B765430,

      P PPXX,

      78BL333

       

      Actually, to eliminate the possible zeros at the beginning. The zero appears if there is only figures.

      How shall I script???