How to use values from middle() function
Using Filemaker Pro 10
I need to take out several character from a string for calculations
Middle (fieldname;3;2;) appears it could do then I need to take the 3rd and 4th character and use in calculations to translate to numbers. (ie: if the 3rd character = A put 2010 in field year.)
Is this possible?