Split number and text from a field
I have a field that I am importing into a FM 12 Database the data comes in as a text field with some numbers and some letters as shown below:
I am looking for a way to split these into two fields, one being the numeric part and the second the letters. I am using the “GetAsNumber” Calculation and I get the number I am looking for. Is there a similar function to return just the letters?
Thanks for any help!