AnsweredAssumed Answered

Parsing Numbers and Letters

Question asked by user28271 on Apr 11, 2018
Latest reply on Apr 14, 2018 by fmpdude

Once before I asked this question but now I find a flaw in the solution.


I have a field that will have a combination of numbers and letters which I need to break up.


My original example was like this:  1 Alt B.


The solution was this:




















But now we have entries like 1 Alt b1.


The above solution drops the 1 after the B.


There are only 1 rule to this field.  It will start with a number.  After the number there will be letters and possibly more numbers.  I need the numbers in front of the letters and then everything else.


1 Alt B1 needs to calculate two fields:  prefix 1, suffix Alt B1