Split column using RegEx (string and special characters)

[Sam7]

I have 1 column of data that I require the Regex tool to split into chunks of 3 lettered string and split the special character that are in between.

What would the code be for known lengths of data and special characters?

Thanks

1 column data set
ANT/CAT*DOG	ANT	/	CAT	*	DOG
CAT/DOG	CAT	/	DOG
ANT\CAT/DOG*BAT/RAT	ANT	\	CAT	/	DOG	*	BAT	/	RAT

[NickSm]

Hey @Sam7 

Can approach it a couple ways, but my take was to use a (\W) expression to find special characters, and use a Regex replace to add spaces to either side of it. Text to columns can then split this out based on the spaces.

You could do text-to-rows and pivot to make it more flexible on the number of columns as well.

[PhilipMannering · Accepted solution]

I would tokenize in the Regex Tool and use the expression,

\W|\w+

workflow 

[benakesh · Accepted solution]

Hi  @Sam7  ,

The regex is same as   @PhilipMannering's  solution   .  Added logic to make  it dynamic  i.e  this works for  different  num of cols .

[Sam7]

Thanks @PhilipMannering and @benakesh 

This is great.  It worked.