Icon

20230410 Pikairos Splitting HTML element into rows

This workflows shows how to split a HTML piece of code based on "
" separators.

The workflow answers the question asked by @Wesley in post 65181 in the KNIME forum.

<td nowrap="">07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011</td>replace(replace(replace($HTML Text$, "</br>", ""), "</td>", ""), "<td nowrap=\"\">", "")Split using "<br> as separatorandaggregate results as a listUngroup the listto reorganize the list itemsinto rowsTable Creator String Manipulation Cell Splitter Ungroup <td nowrap="">07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011<br></br>07/02/2011 - 03/06/2011</td>replace(replace(replace($HTML Text$, "</br>", ""), "</td>", ""), "<td nowrap=\"\">", "")Split using "<br> as separatorandaggregate results as a listUngroup the listto reorganize the list itemsinto rowsTable Creator String Manipulation Cell Splitter Ungroup

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2023-04-10
On NodePit since: 2023-04-11
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: String ManipulationCell SplitterUngrouptagsHTML

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!