Split column using RegEx (string and special characters)

Question

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*DOGANT/CAT*DOG    CAT/DOGCAT/DOG      ANT\CAT/DOG*BAT/RATANT\CAT/DOG*BAT/RAT

philipmannering · Accepted Answer

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

\W|\w+

workflow

benakesh · Accepted Answer

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 .