Convert Text to number

[MB_Rocks]

How to convert 

Coulm a Column b

zero         0%

one          1%

ten           10%

eighty        80%

in alteryx plse help huge data 

[IraWatt]

Hey @MB_Rocks,

Can do it like this:

[MB_Rocks]

How to convert text to numeric 

I have values as zero want to see as 0% 

Coulmn a to  Column b

zero             0%

one              1%   

ten              10%

eighty        80%

in alteryx plse help huge data 

[DataNath]

The only way I can think of doing this is with a lookup table like so:

It's not ideal, but I don't know of any functions to turn written numbers into their digit counterparts. Hopefully somebody else can chime in if they do!