Cell splitter on pattern

[sahil786]

Is it possible to split a column on basis of same pattern?..I am trying to split a column value which can have these character ±/ and i want to split the column value on these operator.Each row can hv multiple ±/ in it…i dont want to use 4 cell splitter…Kindly suggest

[ipazin]

Hello @sahil786,

can you share some examples how cell value looks like before and after manipulation?

Br,
Ivan

[sahil786]

For eg:

Cell can have value like A+B-C-D ,cell splitter output should be A,B,C,D and using ungroup node i will convert this column to four rows

[ipazin]

Hello @sahil786,

you can use following function inside String Manipulation node to replace +- with comma:
replaceChars($column1$,"+-" ,",," )

Then use Cell Splitter followed by Ungroup if that format is what you are after.

Br,
Ivan

[sahil786]

Thank you @ipazin i will do it

[sahil786]

regexReplace worked.

[ipazin]

Sure it did
Ivan