Icon

kn_​forum_​39383_​csv_​multiline_​import

Try to read in a very complicated CSV format - best guess approach ....

Try to read in a very complicated CSV format - best guess approach ....

=> check if this works on all files!! Try to read in a very complicated CSV format - best guess approach .... read the CSV file/data/Extract path informationsv_csv_file"file.separator" (STRING: \)create path$$ROWINDEX$$ = 0 => 1$Column0$ LIKE ";I*" => $$ROWINDEX$$mark the blocksso they can be split laterbring the markerto thewhole blockSTARTmake sure thetransposed file isdelted(not 100% necessary, from anapprocah whereI tried to append lines)write intermediateCSV fileENDreadintermediateCSV file$Column0$ LIKE ";TOTAL*" => FALSETRUE => TRUE(?<=\\;)(.*?)(?=\\;)get theSERVICIO stringMISSING $group_id$ => FALSE$group_id$ = 1=> FALSEfirst_semicolonrest_string_1$first_semicolon$ +1second_semicolonSERVICIOelminitate thelines with theSERVICIO entries(they will be dealt with separately)$group_id$ = 1 => FALSE$Column0$ LIKE ";;*" => FALSETRUE => TRUE$Counter$ = 1 =>"SERVICIO"TRUE => $SERVICIO$Node 71Node 72add SERVICIOto each line$Column0$ LIKE ";;*" => FALSE$group_id$ = 1 => TRUETRUE => FALSENode 76Node 77combined stringNode 79join("SERVICIO", $combined string$)v_table_filecreate path_transposed_transposedv_excel_filecreate path$Counter$ = 1 => TRUETRUE => FALSEreplace($Column0$,"" ,"" )=> replace double blanksreplace($Column0$,";Tiempo de conversación;Tiempo de espera" ,"" )replace($Column0$,"" ,"" )=> replace double blanksNode 93!!!!static rename of data CSV Reader List Files/Folders Path to URI URL to File Path Java Snippet(simple) Extract SystemProperties Table Columnto Variable String to Path Rule Engine Missing Value Table Row ToVariable Loop Start DeleteFiles/Folders Try (VariablePorts) Catch Errors(Var Ports) Merge Variables CSV Writer Variable Loop End CSV Reader Rule-basedRow Filter Regex Split Rule-basedRow Filter String Manipulation String Manipulation Math Formula String Manipulation String Manipulation ReferenceRow Filter Counter Generation Rule-basedRow Filter Joiner Rule Engine Column Resorter Column Filter Column Combiner Rule-basedRow Filter Column Filter Transpose Column Combiner Concatenate String Manipulation Java Snippet(simple) String to Path Table Writer Excel Writer Java Snippet(simple) String to Path Merge Variables Rule-basedRow Splitter String Manipulation String Manipulation String Manipulation Concatenate Column Rename => check if this works on all files!! Try to read in a very complicated CSV format - best guess approach .... read the CSV file/data/Extract path informationsv_csv_file"file.separator" (STRING: \)create path$$ROWINDEX$$ = 0 => 1$Column0$ LIKE ";I*" => $$ROWINDEX$$mark the blocksso they can be split laterbring the markerto thewhole blockSTARTmake sure thetransposed file isdelted(not 100% necessary, from anapprocah whereI tried to append lines)write intermediateCSV fileENDreadintermediateCSV file$Column0$ LIKE ";TOTAL*" => FALSETRUE => TRUE(?<=\\;)(.*?)(?=\\;)get theSERVICIO stringMISSING $group_id$ => FALSE$group_id$ = 1=> FALSEfirst_semicolonrest_string_1$first_semicolon$ +1second_semicolonSERVICIOelminitate thelines with theSERVICIO entries(they will be dealt with separately)$group_id$ = 1 => FALSE$Column0$ LIKE ";;*" => FALSETRUE => TRUE$Counter$ = 1 =>"SERVICIO"TRUE => $SERVICIO$Node 71Node 72add SERVICIOto each line$Column0$ LIKE ";;*" => FALSE$group_id$ = 1 => TRUETRUE => FALSENode 76Node 77combined stringNode 79join("SERVICIO", $combined string$)v_table_filecreate path_transposed_transposedv_excel_filecreate path$Counter$ = 1 => TRUETRUE => FALSEreplace($Column0$,"" ,"" )=> replace double blanksreplace($Column0$,";Tiempo de conversación;Tiempo de espera" ,"" )replace($Column0$,"" ,"" )=> replace double blanksNode 93!!!!static rename of dataCSV Reader List Files/Folders Path to URI URL to File Path Java Snippet(simple) Extract SystemProperties Table Columnto Variable String to Path Rule Engine Missing Value Table Row ToVariable Loop Start DeleteFiles/Folders Try (VariablePorts) Catch Errors(Var Ports) Merge Variables CSV Writer Variable Loop End CSV Reader Rule-basedRow Filter Regex Split Rule-basedRow Filter String Manipulation String Manipulation Math Formula String Manipulation String Manipulation ReferenceRow Filter Counter Generation Rule-basedRow Filter Joiner Rule Engine Column Resorter Column Filter Column Combiner Rule-basedRow Filter Column Filter Transpose Column Combiner Concatenate String Manipulation Java Snippet(simple) String to Path Table Writer Excel Writer Java Snippet(simple) String to Path Merge Variables Rule-basedRow Splitter String Manipulation String Manipulation String Manipulation Concatenate Column Rename

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: A9699459
Created at: 2022-02-07
On NodePit since: 2022-02-11
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: csvmultilineimport

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

Try NodePit Runner!