Extract quantities from description column

[eleee3]

Hi there,

I have a dataset which looks like this:

Description	Quantity
Lounge (Qty8)
Picture Qty11
Fridge Qty 6
Mugs (Qty100)
Room 205
Room 206
Hallway 0-12m

I want Alteryx to extract unit quantities from the description column (but not other numbers) such that my final dataset looks like this:

Description	Quantity
Lounge (Qty8)	8
Picture Qty11	11
Fridge Qty 6	6
Mugs (Qty100)	100
Room 205
Room 206
Hallway 0-12m

Could someone please help me set this up?

Thanks in advance!

[ShankerV · Accepted solution]

Hi @eleee3 

One way of doing this with the help of Regex tool.

Many thanks

Shanker V

[eleee3]

Thanks, @ShankerV! Always appreciate your help.