Splitting HTML element into rows

[Wesley]

Hello,
I have 1 row & 1 column data in XPath as below:

Would you please help me how to split it become 16 rows contains like 07/02/2011 - 03/06/2011?
Appreciate your help.

[aworker]

Hi @Wesley & welcome to the KNIME community forum !

The following workflow may do the trick:

20230410 Pikairos Splitting HTML element into rows – pikairos

Hope it helps.

Best
Ael

[gonhaddock]

Hello @Wesley
I think this post in a different topic may work for your use case:

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

BR

[Wesley]

Hi @aworker ,
Thank you very much…

[aworker]

Hi @Wesley

My pleasure. Hope it worked well !

Please reach out again if you need any more help.

Best wishes
Ael