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.
