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 ?