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 NameNode 30Fixed 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 String To Number 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 NameNode 30Fixed 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 String To Number

Nodes

Extensions

Links