I have a text file that is comma separated like
Nature Reviews Genetics , NAT REV GENET , 1471-0056 , 1471-0064 , 2016/2017,40.282,50,
Nature Reviews Genetics , NAT REV GENET , 1471-0056 , 1471-0064 , 2015,35.898,51,
Nature Reviews Genetics , NAT REV GENET , 1471-0056 , 1471-0064 , 2014,36.978,59,
Nature Reviews Genetics , NAT REV GENET , 1471-0056 , 1471-0064 , *This factor is calculated based on the citation information of journals in our database.,
Cell , CELL , 0092-8674 , 1097-4172 , 2016/2017,30.41,455,
Cell , CELL , 0092-8674 , 1097-4172 , 2015,28.71,437,
Cell , CELL , 0092-8674 , 1097-4172 , 2014,32.242,436,
And I need it parsed and looped so it will call a function with each element. Like
Public Function Save_Data(JournalName As String, JournalISO As String, ISSN As String, ESSN As String, Year As String, Impact As String, citations As String)
' I will add the database call
End Function
I've added the file and also an outline of the VB.net function. It needs to call each row.