7 Replies Latest reply on Aug 21, 2009 10:08 AM by RickWhitelaw

    Fixing Number lengths - adding 0's to the start of a number

    henryoswald

      Title

      Fixing Number lengths - adding 0's to the start of a number

      Post

      I need to export some data so all the numbers are the same length (6 digits),

      i.e. 8.348 beomes 008.348,

      79.648 becomes 079.648, 

      and 148.432 stays at 148.432

       

      Does Anyone know a way of doing this without scripting? (its 201,596,725 records!)

       

      many Thanks!