4 Replies Latest reply: Apr 23, 2013 9:09 AM by Sam Vile RSS

    Scripting help required please

      Good afternoon everyone,

       

      I'm currently stuck on an issue with some data within a field in one of my tables. The field is named INDXFLD and is currently formatted to look like this:

       

      • 000047398F

       

      The issue I have is I need to reformat it so the 'F' is at the beginning and the preceeding zero's are removed, it should end up looking like this:

       

      • F47398

       

      Can anyone help me please, the number of zero's can change but it will always start with the first digit which isn't a zero.

       

      Thanks is advance.