SOLVED
How split string with numbers and text into 3 columns
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
deepnandi
6 - Meteoroid
‎09-07-2020
06:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am new to Alteryx and I need help in segregating string into 3 different columns.
[{Name= Final Budget, Id=87FB, Amount=400.02}, {Name=Initial Quote, Id=EB8F2F8D-66C0, Amount=890.73}, {Name= Working Budget, Id=CF6000,Amount=50.00
I need to segregate the above into 3 columns Name, id, Amount
Name | id | Amount |
Final Budget | 87FB | 400.02 |
Initial Quote | EB8F2F8D-66C0 | 890.73 |
Working Budget | CF6000 | 50 |
I tried the Regex tool but was not able to split it into columns. Help will much appreciated.
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Regex
5 REPLIES 5
seinchyiwoo
Alteryx Alumni (Retired)
‎09-07-2020
08:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
grazitti_sapna
17 - Castor
‎09-07-2020
09:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
grazitti_sapna
17 - Castor
‎09-07-2020
10:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Danish409
7 - Meteor
‎09-08-2020
02:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @deepnandi
Alternatively you can also do it with the help of Text to Column & Transform tool.
Please Find the attached Workflow.
‎09-08-2020
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks it worked like a charm. Thanks for the help again