Icon

kn_​forum_​43962_​file_​reader_​complex_​format

Import complex txt / csv file with changing internal structure (43962)

Import complex txt / csv file with changing internal structure (43962)

Import complex txt / csv file with changing internal structure (43962)https://forum.knime.com/t/file-reader-complex-format-problem/43962/7?u=mlauber71 readthe whole filesearch for.txt files$column1$ LIKE "*Median*" AND $column1$ LIKE "*Expected*" => $Counter$line_start$column1$ LIKE "*End Of Results*" => $Counter$line_endkeep numeric columnsFile Nameextract nameand pathNode 17line_startline_startFlow variables forPathn of lines to skiplength of table/data/result.xlsx Fixed WidthFile Reader List Files/Folders Path to URI Table Row ToVariable Loop Start Counter Generation Rule Engine Rule Engine Merge Variables Column Filter ConstantValue Column URL to File Path GroupBy Math Formula Math Formula Table Rowto Variable File Reader Loop End Excel Writer Import complex txt / csv file with changing internal structure (43962)https://forum.knime.com/t/file-reader-complex-format-problem/43962/7?u=mlauber71 readthe whole filesearch for.txt files$column1$ LIKE "*Median*" AND $column1$ LIKE "*Expected*" => $Counter$line_start$column1$ LIKE "*End Of Results*" => $Counter$line_endkeep numeric columnsFile Nameextract nameand pathNode 17line_startline_startFlow variables forPathn of lines to skiplength of table/data/result.xlsxFixed WidthFile Reader List Files/Folders Path to URI Table Row ToVariable Loop Start Counter Generation Rule Engine Rule Engine Merge Variables Column Filter ConstantValue Column URL to File Path GroupBy Math Formula Math Formula Table Rowto Variable File Reader Loop End Excel Writer

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: m_lauber
Created at: 2022-06-09
On NodePit since: 2022-06-09
Last update: 2024-05-01
Created with KNIME version: v4.5.2
Tags: txtimporttablecomplex

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

Try NodePit Runner!