4 Replies Latest reply on Oct 6, 2014 11:02 AM by philmodjunk

    Split number and text from a field



      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!