2 Replies Latest reply on Dec 3, 2013 11:40 AM by jared944

    Formatting Number String with Decimal

    jared944

      Title

      Formatting Number String with Decimal

      Post

           Hello everyone,

           I have a table with a keyfield that contains a series of numbers with either four or five digits : 

           1234

           12345

           I would like to create a script that would insert a decimal after the third digit :

           123.4

           123.45

           The table has over 10,000 entries, so doing this by hand would not be the most effective way to do this. Any help would greatly be appreciated.

            

           Thanks!
            

           Jared