Icon

kn_​forum_​43962_​file_​reader_​complex_​format_​ipazin

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.xlsxFlow variables forPathn of lines to skiplength of tableNode 27Node 28File NameFixed 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 File Reader String Manipulation Cell Splitter ConstantValue Column 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.xlsxFlow variables forPathn of lines to skiplength of tableNode 27Node 28File NameFixed 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 File Reader String Manipulation Cell Splitter ConstantValue Column

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-14
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!