SOLVED
Split data from single column into 2 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
markosxman
5 - Atom
‎05-18-2021
02:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I would like to be able to split Column 1 into 2 columns.
One with the "number" one with the "description"
1-7811 Cash:Mizuho AUD | 725,009.58 |
1-7812 Cash:Mizuho USD | 43,767.90 |
1-7816 Cash:ANZ AUD | 10,823.24 |
1-7817 Cash:Term Deposit | 154,040.00 |
1-7823 Receivables - current:Interest receivable | 75.96 |
1-7870 Prepayments | 52,239.04 |
Am struggling to find the right commands!
Solved! Go to Solution.
Labels:
- Labels:
- Parse
4 REPLIES 4
17 - Castor
‎05-18-2021
02:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @markosxman one approach is to use regex to split your column. The expression below will find everything up to a digit with white space and put that in column and then put everything else into a second column.
22 - Nova
‎05-18-2021
02:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @markosxman
You can us regex tool parse mode and below expression to split into columns.
(\d\-\d+)\s(.*)
Workflow:
Here is a resource on
Regex tool parse mode : https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415
Hope this helps 🙂
ACE Emeritus
‎05-18-2021
02:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-18-2021
03:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks that worked perfectly
