Regex - tokenize to separate at specific comma intervals
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI everyone, I have a unique sort of expression I am trying to write but can't figure it out!
in my data set I have a list of values (last column) that are separated by a comma. I was to split the data so that the final result is that there are a max of 8 values in each column or until all [groups of 8] have been split.
Bonus points if I can get it in the format of the 3rd print screen.
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VXM516
Can you provide sample data.
Regex like below in regex parse mode should work.
^([\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the prompt response @atcodedog05, the formula didn't work for me. Have attached the Sample file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VXM516 ,
I found the attached approach easier than trying to use RegEx. Hopefully it helps.
Edited:
I added a reporting Table tool to get the results to look like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
this method worked perfectly - thank you @phottovy!
