AnsweredAssumed Answered

Split number and text from a field

Question asked by Badam on Oct 6, 2014
Latest reply on Oct 6, 2014 by philmodjunk


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:

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!