RegEx Parsing Syntax Question

[Bren312]

Hi everyone, I'm hoping someone can help me with a RegEx problem. I've got one column called 'Product Name' which contains the company name and product description (3m File Hangers, for example).
I'm trying to create a column for 'Company Name' and a column for 'Product Description' (so, 3m in 'Company Name' and 'File Hangers' in 'Product Description').

I've tried a (\w*\d*\W*)\s RegEx but it isn't ticking the boxes for every situation. Can anyone help me out with this? I'm using version 2019.2 and have attached a workflow. Thanks everyone!

Bren

[Qiu · Accepted solution]

@Bren312 
I assume the two columns are seperated by the first space.

[Bren312]

Thanks @Qiu; top notch stuff!  You are correct (and I should have specified) that the two columns were separated by the first space.  Sometimes I think I'm getting the hang of RegEx and then it throws me for a loop.  Thanks again!

Bren

[Qiu]

@Bren312 
Glad to help.

I always use this one to test my regex, and lets get better and better for the RegEx.

https://regex101.com/