Regex - tokenize to separate at specific comma intervals

[VXM516]

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.

[atcodedog05]

Hi @VXM516 

Can you provide sample data.

Regex like below in regex parse mode should work.

^([\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*,?[\w\-]*)

[VXM516]

Thank you for the prompt response @atcodedog05, the formula didn't work for me. Have attached the Sample file

[phottovy · Accepted solution]

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:

[VXM516]

this method worked perfectly - thank you @phottovy!