3 Replies Latest reply on Jul 19, 2018 5:57 PM by macharia lamar

    Leading Zero problem

    Aanchal Shukla

      Hi Guys,

      I need some help to resolve one issue, i named it "leading zero issue".

      I want to remove any no of zeros from a value starting from 1st position till 1st non zero numbers.

      suppose i got string or numbers from DB .

      ex.   1) 0000023540.

             2) 0003406507.

      I want to remove 5 zero from 1st one and 3 zero from 2nd one.

      Please suggest how can i calculate.

       

      Thanks in advance