Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting Numeric Text to actual Numbers

lconnolly
6 - Meteoroid

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

 

 

4 REPLIES 4
RobertOdera
13 - Pulsar

Hi, @lconnolly 

 

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

I hope you find it helpful - Cheers!

 

RobertOdera_0-1683067958658.png

 

 

 

Qiu
21 - Polaris
21 - Polaris

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

lconnolly
6 - Meteoroid

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

Labels
Top Solution Authors