Please help with Regex Parse

[HW1]

Hi,

I have a column of values as:

Value

1 1.5cm 08 Mar 2021 1.5m Co-Mingle Recycling Bin - Dkt#11028467 $18.00

I want it to split as:

QTY	ITEM	Date	Description	Ref	Amount
1	1.5cm	8-Mar-21	1.5m Co-Mingle Recycling Bin	11028467	$18.00

What should be my regex code?

Thanks

[Emil_Kos · Accepted solution]

Hi @HW1,

I hope it will work for your data set:

Good luck

[messi007]

@HW1,

Please see below

Attached the workflow,

Hope this helps!

Regards