Help on splitting column data using Regex and Text to Column tools?

[jakemiroquai]

Hi there, I have been looking for a solution to split the column data I have into 5 different columns as shown in the image I have attached. It would be great if I can get some help on converting this string "GaaEe 2014 Death Only Z countries. Non smoker. Standard" into an expression that Alteryx understands to then be split into 5 columns. Any help would be greatly appreciated!

[jakemiroquai]

I have attached a new workflow along with a text input showing my desired goal output. Thank you!

[jakemiroquai]

Hi @caltang , I have attached a new workflow along with a text input in the workflow showing a desired output that I wish to achieve, thank you!

[caltang · Accepted solution]

In that case, you don't need Regex or Text-to-Columns. Just use the filter tree method!