3 Replies Latest reply: Aug 25, 2017 3:50 AM by Xiaoyu Yang RSS

    identify String or Text and eleminate the zeros at the beginning

    Xiaoyu Yang

      Hey Guys,

       

      I have a dimension "Material Number", where the numbers can be

      000002525451012,

      0000000695748,

      P IND XXX,

      B7TRCXX

       

      As result I shall get:

      2525451012,

      695748,

      P IND XXX,

      B7TRCXX

       

      if only contains figures and there are zeros at the beginning then the zeros at the beginning have to eliminated. If it contains Letters, the material number shall remain so.

       

      How shall I write in the script?

       

      thank you.