Parsing using regex

[lavorarchi]

Hi would appreciate some help with parsing using REGEX the following data

Input Data

Total 123-456 Description of the total

500000 Description of item

600-123 Another line description

Irrespective of the lines in each cases I need to parse the "123-456" , "500000" and "600-123" in one column and in another column I need the remaining descriptions e.g. Total Description of the total, Description of item and "Another line description" using the example above. 

[mpennington]

I think this should work:

Edit: Corrected image and workflow, missed one case. Sorry for the confusion.

[lavorarchi]

Hi @mpennington @thank you very much. I have noticed the 2nd row is not parsing the numbers from the description. How can I fix that? 

[mpennington · Accepted solution]

Sorry about that, I fixed it above.

The RegEx:

REGEX_Replace([Input Data],".*(\d{3}-\d{3}|\d{6}).*", "$1")

[lavorarchi]

Much appreciated thank you.