SOLVED
Reg Ex - pull numerics only
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
VenuG
5 - Atom
12-23-2018
10:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Expression
2 REPLIES 2
cmcclellan
14 - Magnetar
12-23-2018
11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
12-24-2018
02:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@cmcclellan
Thanks for solution. You have provided exact answer.
