### Title

Split number and text from a field

### Post

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:

50.00 GB

0.00 B

250.00 TB

100.00 GB

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!

If there is always a blank between number and text, You can separte it using the 'position' function and the 'middle' function, Otherwise You could get the data using the 'filter' function