Parse numbers from String

[ArnabSengupta]

Hi All,

I have a dataset where text contains numbers and there is no delimiter/ uniformity to parse numbers only from the text.

Input

Data

01A

02B

02BB

01AAA

11AA

12B

The desired output 

Data	Output 1	Output 2
01A	1	A
02B	2	B
02BB	2	BB
01AAA	1	AAA
11AA	11	AA
12B	12	B

Please advise as how I can parse accordingly.

Help is much appreciated 

[kamal03 · Accepted solution]

If the front 2 digits remain the same then we can solve this by using the regex parse tool using this expression:- (\w{2})(\w*)

Let me know if your requirement is something different.

[TimN · Accepted solution]

I tried a similar way

[binu_acs · Accepted solution]

@ArnabSengupta Another option

[caltang · Accepted solution]

Another solution for you @ArnabSengupta :

[malteryx1]

Here the below Solution without using Regex.