Regex expression for parsing integars, decimels, and strings

[cdahl001]

Howdy do! 

Need some help with a Regex expression. I'm taking a column of data that is supposed to contain a number and then a string, and separating them into two columns respectively. The thing is, not every value contains the number at the beginning, and some values have spaces between the number and the string. Some even have decimal numbers at the beginning, which will need to be parsed and kept as a decimal in the output. How do I account for all these whatifs?

[Greg_Murray · Accepted solution]

@cdahl001 

you can add optional capturing groups with '?'. 

Hope that helps,

Greg