Return to FileMaker.com
Use only first three digits.
I have a mm field in which say 3500 is added.This will be used in a part number so can only have 3 digits as the part number is 18 digits. The length makes up the very last part of the part number.
so if it was 3500 in the part number i would like to have just 350.Or if it is input as 0350 the last 0 should be taken away eg 035
Thanks for any help
Left ( textfield ; 3 ) will return the leftmost 3 characters of the text in "textfield".
Retrieving data ...