Split a column based on a pattern of values as a delimiter?

Question

I have the following data included in my first row:

Pan, Dongning,Mao, Chunxiao,Wang, Yong-Xu

I would like to split each of the names into separate columns (Pan, Dongning -- Mao, Chunxiao -- Wang, Yong-Xu)

I am noticing that the unique identifier is a comma followed by no space. Is it possible to use this as delimiter. For example, can I use the text to columns tool to specify that I want to split the text only if there is a comma followed by no space?

AngelosPachis · Answer

Hi @qasdxx ,

I think you can achieve this but it's not that straight forward with a text to columns tool. A regex tool configured to tokenize might work better.

I'm no RegEx expert, but this expression seems to be doing what you are after.

(\w+,\s\w+),?

Cheers,

Angelos

example.yxmd