5 Replies Latest reply: Mar 11, 2015 11:41 AM by Andrew Whitfield RSS

    Convert String to Number

    Jason Lai

      Hi All,

       

      I need to convert a 16 character string into a number. The tricky thing is, the field is always a 16 character string in the form of:

      "000000000001234" or "000000132454623" or "000000012300433".

       

      As the last example suggests, I cannot simply trim all the 0's from the left hand side.

       

      Any help would be much appreciated.

       

      Cheers,

      Jason