How do I specify a calculation function to omit/exclude a leading letter/number/character in the output filed of a FileMaker Pro database?
Here is what I exactly mean:
Lets say I have a barcode that translates into A123ABC4567, when the barcode is scanned into an input field called "Serial Number" I want it to be accepted as 123ABC4567, removing the prefix letter "A" automatically in the output field when printing the label. Any idea how? I just need the correct calculation function or formula. FileMaker Pro 10