Formula to Separate String and Number into separate columns

[shelbybradley]

Hello, 

I am trying to separate a number attached to a string into its own column. Here is a depiction of my current data:

 The formula I have now (below) is not working on strings with double digit numbers attached:

 This is my current output. As you can see, the formula only separates the last digit of a 2-digit number.

 

Can someone recommend another formula / approach to help me with this issue?

Thanks!

 

[atcodedog05]

Hi @shelbybradley 

use regex tool parse method like below

Hope this helps : )

[binuacs]

@shelbybradley 

REGEX_Replace([Name], '[^\d]+', '')

[shelbybradley]

Thanks - @binuacs 

I now have that ID in the new column, as shown below:

 But how do I separate them so that the number is no longer is the "name" column like below?

 

[atcodedog05]

Hi @shelbybradley 

Try this if you want to use formula tool only

Hope this helps : )

[binuacs]

@shelbybradley  another option for extracting only strings

REGEX_Replace([Name], '[\d]+', '')