10 Replies Latest reply on May 26, 2010 8:43 AM by comment_1

    how to remove the first "0" in certain field

    Springkiang

      Title

      how to remove the first "0" in certain field

      Post

      Hi, everyone!

      I am new to Filemaker,I find it is of great help to me

      there is a field in my table and the value like this:

       

      MIC

      0.016

      0.064

      0.125

      <=0.008

      >256

      8

      0.5

       

      I want to remove the first "0", if the value is less than 1, like this below:

       

      MIC

      .016

      .064

      .125

      <=.008

      >256

      8

      .5

       

      can anyone can help me?

      Thanks!