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.
Hi,
As you want to create macro for your existing excel sheets to do data import from txt. I will do that for you. Please share your data sheet so that I can do this task for you.
I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such automation projects. Please give me this opportunity to work on your project.
Quality work with high accuracy and 100% customer satisfaction is guaranteed.
Thanks,
Peter
Hello sir, just saw your project description and ready to work with you. I have experience working in this field for 1 years and have an experienced team. So I am confident about completing this task perfectly. If you consider me then please open a chat session for further discussion.
hi, i recently done similar job using data processing, excel , vb.net, i have experience of 5 years, i have skills to do this job perfectly and in time, you can hire me for this job, this type of projects are very easy for me to do, hope you can hire me for this job thank you
Hi there!
I am an experienced person with dynamic professional capabilities. I do have excellent MS Excel skills, I would love to do it for you. Please inbox me for further details.
Kind regards,