AnsweredAssumed Answered

Breaking up number and text in a field

Question asked by user28271 on Jul 8, 2017
Latest reply on Jul 9, 2017 by bigtom

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.