Split string containing csv data into a table

I have a string containing csv data like

“colA”,“colB”,colC"
“red”,“apple”,10
“yellow”,“banana”,5

and I need to transform it into a table for further processing.

tried CellSpliter on newline -> transpose -> CellSplitter on “,” but how to specify a newline as delimeter ?
tried RegexSplit but there every capture group has to be defined and my real table (not the example above) is huge in both dimensions…

Can anybody help me out here ?

Hey, thanks for reaching out on the forum, always happy to help.

If you check the box in the Cell Splitter node to enable use of \ as an escape character you can use \n to denote a new line and use that as your delimiter.

1 Like

That did the trick, perfect solution. Thank you very much.

1 Like