Dynamic Cell Split to column

[sw1336]

Hello all,

If I have the following table, how could I split the cells in to columns after the date? The issue is Mod1, Mod2, Mod3 (or anything else) is dynamic. The only constant is the date.

I would like to do it in Regex, but couldn’t figure out using Regex in the Cell Splitter node.

Any ideas on how to split this?

Thank you.

[gonhaddock]

Hello @sw1336
You can test ‘String Manipulation’ node with the following code:

regexReplace($New Col$, "(?:(Mod[\\s\\d-]+))", "$1|")

A ‘Cell Splitter’ node afterwards with “|” (pipe) as delimiter.

BR

[sw1336]

Many thanks, @gonhaddock! That worked.

[gonhaddock]

Great!!
Would you check mark my previous post as the solution?

Thx