Alteryx Designer Desktop Discussions

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

Reg Ex - pull numerics only

VenuG
5 - 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

 

2 REPLIES 2
cmcclellan
13 - Pulsar

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

VenuG
5 - Atom

@cmcclellan

 

Thanks for solution. You have provided exact answer.

Labels