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 Column | Need Out put |
E Sal | E Sal Original |
100k | 100000 |
k 150 | 150000 |
110k | 110000 |
90 k | 90000 |
105 k | 105000 |
110K | 110000 |
85K | 85000 |
90Thousand | 90000 |
75000 | 75000 |
55K | 55000 |
150 K's | 150000 |
60 Thusd | 60000 |
thousands : 70 | 700000 |
Please help on this scenario... thanks in advacne
Solved! Go to Solution.
@cmcclellan
Thanks for solution. You have provided exact answer.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |