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

How about

Let (

_rows = Substitute ( "1 At B1" ; " " ; "¶");

_first = GetValue (_rows ; 1);

_second = GetValue (_rows ; 2) & " " & GetValue (_rows ; 3)

];

<<return either _first or _second >>

)