# Split a multirow string into different rows and columns

**URL:** <https://forum.knime.com/t/split-a-multirow-string-into-different-rows-and-columns/70267>\
**Category:** KNIME Analytics Platform\
**Created:** [July 4, 2023, 4:11pm UTC](https://forum.knime.com/t/split-a-multirow-string-into-different-rows-and-columns/70267 "2023-07-04T16:11:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DiegoCorreiaXTL](https://forum-cdn.knime.com/user_avatar/forum.knime.com/diegocorreiaxtl/32/50109_2.png) [@DiegoCorreiaXTL](https://forum.knime.com/u/DiegoCorreiaXTL)\
**Post date:** [July 4, 2023, 4:11pm UTC](https://forum.knime.com/t/split-a-multirow-string-into-different-rows-and-columns/70267/1 "2023-07-04T16:11:02Z")

</div>

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?

 ![Row Split](https://forum-cdn.knime.com/uploads/default/original/3X/9/e/9e7b0399c9a4c81d7be9ae5be9dee8fed83d5a98.png)

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [July 4, 2023, 4:50pm UTC](https://forum.knime.com/t/split-a-multirow-string-into-different-rows-and-columns/70267/2 "2023-07-04T16:50:02Z")

</div>

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

> [@Mulit-line string input into table](https://forum.knime.com/t/mulit-line-string-input-into-table/47576/2):
>
> Hi @kienerj I’m not sure that I fully understood your your request. An example of input → aimed output would help… 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" BR

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

BR

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [October 2, 2023, 4:50pm UTC](https://forum.knime.com/t/split-a-multirow-string-into-different-rows-and-columns/70267/3 "2023-10-02T16:50:08Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.