Iterating through csv formatted string

Questions
, ,
1

Hi
I want to write the contents of a csv file to a SQL table, and I need to iterate through each row in the csv and write it row by row. Is there a way to iterate through a csv formatted string and do this?

The string is in the format:

column1;column2;column3;column4;column5;column6;column7;
value;value;value;value;value;value;value;
value;value;value;value;value;value;value;
value;value;value;value;value;value;value;

image
image1845×617 58.6 KB

I need a module that iterates throught the parsed csv so that I can insert it into the SQL table. I need to do this since I can only insert values from the first row of the CSV, the other ones are inaccessible:

image
image1740×1269 179 KB

3

There’s no other module that lets me write to the SQL server other than the one in my screenshot, and since it takes the value of a single cell for each column, I suspect that I need to loop through the rows in the CSV and insert the cells for each iteration

4

Hi @Admirlj

The Parse CSV module is an iterator itself. It will return a bundle for each row read. Then the module(s) after the Parse CSV will execute once for each bundle (row parsed).

Just map the DB fields to the colum names.

@damato