9 Replies Latest reply on Jul 9, 2017 6:29 PM by bigtom

    Breaking up number and text in a field


      I have a field VERSION that is a combination of number and text with no rules therefore the field is a TEXT field.  I need to setup two calculated fields to extract just the number part and just the text part.


      Example could be 1, 1 Alt, 1 Rev, MX 1, and so on.


      I can make one field a calculation of the VERISON field as a number which will strip all the text, but not sure the best way to remove the number and leave the test.