Converting Numeric Text to actual Numbers

[lconnolly]

Hi there,

I need some help. Trying to automate one of my older workflows to be more dynamic since the need to run it was increased from yearly to weekly, due to all the changes in our warehouse. The issue I am stuck on is identifying numerical text and turning it into actual numbers. Example below:

Four Pallets
Thirteen Pallet
Fourteen Pallet
Ten Pallet
Twenty Five Pallet
Fifteen Pallet
Fifty Pallets

This changes weekly based on the needs of the warehouse, as these are all digital locations, the pallet count changes frequently. I need to be able to convert the numerical text value to a num value to so that I can add multipliers accordingly.

Thank you in advance for your help.

Leland

[RobertOdera]

Hi, @lconnolly 

Try something like the one below (please see tool annotations).

I hope you find it helpful - Cheers!

[Qiu · Accepted solution]

@lconnolly 
I dont know the order of your data, and I think below will work only upto thousands.

Let me if there is any improvement can be done in your actual data.

[ArtApa]

Hi @lconnolly - These weekly challenge are exactly what you may be interested in: 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-234-Spell-It-Out-For-Me-Part-1/td-p/6363... 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-235-Spell-It-Out-For-Me-Part-2/td-p/6409... 

[lconnolly]

Thank you all for your help! This will save so much time!