community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Reg Ex - pull numerics only

Atom

Hi Every one,

 

I am newbe to Alteryx. i have column (Source Column) like below...

 

I need output column like second column using reg expressions.

 

Source is "Spreadsheet"...

 

Source ColumnNeed Out put
E SalE Sal Original
100k100000
k 150150000
110k110000
90 k90000
105 k105000
110K110000
85K85000
90Thousand90000
7500075000
55K55000
150 K's150000
60 Thusd60000
thousands : 70700000

 

Please help on this scenario... thanks in advacne

 

Alteryx Partner

I used a regex_replace, but you still have to look at the K as well :) 

Atom

@cmcclellan

 

Thanks for solution. You have provided exact answer.

Labels