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
can you share some examples how cell value looks like before and after manipulation?
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
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.
Thank you @ipazin i will do it
Sure it did
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.