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:

 

Trim

(

 

 

Substitute(a_Version_Name;

["0";""];

["1";""];

["2";""];

["3";""];

["4";""];

["5";""];

["6";""];

["7";""];

["8";""];

["9";""]

)

)

 

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

Outcomes