9 Replies Latest reply: May 22, 2015 2:33 PM by Vinay Bangari RSS

    how to append zero in the front of the data of the feild

    Vinay Bangari

      i have delivery number . And this delivery number sometimes will have 9 digits , 8 digits or 7 digits. But i want the end column data should have as 10 digits with zeros in the front .

      For example if i have


      1234567--- output:  0001234567

      12345678-- output: 0012345678

      1234567891--- since it is 10 digits it should not change.