Converting Numeric Text to actual Numbers

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

Developer Tools

Dynamic Processing

Accepted answers

@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.

0503-lconnolly.yxzp

All comments

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

I hope you find it helpful - Cheers!

For_Iconnolly.yxzp

@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.

0503-lconnolly.yxzp

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/636318

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703