5 Replies Latest reply: Mar 11, 2015 11:41 AM by andy whitfield RSS

    Convert String to Number

      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.