3 Replies Latest reply: Dec 21, 2015 8:23 AM by Prashanth Reddy Nasi RSS

    How to remove alphabets and leading zerosin a column?

    Prashanth Reddy Nasi

      load inline [

      Department

      emplyoye,

      distribution,

      G101010

      GA201020

      S081

      G00089

      GA00123

      ];

       

       

      How to remove names,alphabets and leading zeros

       

      Expected output:

      Department:

      101010

      201020

      81

      89

      123

       

       

       

       

      Thank you