6 Replies Latest reply: Apr 20, 2015 10:29 AM by Jannet San RSS

    Problem with number format


      I'm having the following problem with number formats:


      This is the number with its original format: 123456789

      what I need to do is get rid of the last number so it can be like this: 12345678


      to do so, i use the following script: If(Len(number)=9,Left(number,8).


      The problem is when I have this number: 0123456789

      I have to get rid of the last and the first number so I can get: 12345678


      Help please

      Thank you very much!