AnsweredAssumed Answered

how to remove the first "0" in certain field

Question asked by Springkiang on May 26, 2010
Latest reply on May 26, 2010 by comment_1

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!

Outcomes