Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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