Split a multirow string into different rows and columns

[DiegoCorreiaXTL]

Hi all,
Hopefully someone can help.
I’m in the process of converting a PDF file into a CSV using Tika Parser. I got to a point now that all the PDF content is inside a row. I want to break it into different rows and columns but was not able to make it work. Following is a screenshot of the output table of a String Manipulation. Can someone advise how to break it into rows and columns now?

[gonhaddock]

Hello @DiegoCorreiaXTL
As a starting point, you may want to take a look into this topic:

Mulit-line string input into table

Hi @kienerj I’m not sure that I fully understood your your request. An example of input → aimed output would help… [image] Do you have a multi-line text in a cell like this one? [image] And you want to split it in rows. Or do you have a text split in rows? ‘Cell Splitter’ node delimiter == "\n" Then Unpivot [image] Then, do you want to merge it in a cell? ‘Pivoting’ ‘Column Aggregator’ node columns, wildcard == "*_Arr*" concatenate, delimiter == "\n" [image] BR

After breaking it into rows, you would probably need a cell splitter node, with space character as delimiter.

BR