[VB.NET] How to combine all csv files from the same folder into one data

[thuan2210]

I want merge multiple csv files with same layout from the same folder

example :

csv1.csv

ID, PINA,PINB,PCS

1,100,200,450

2,99,285,300

csv1.csv

ID, PINA,PINB,PCS

1,100,200,999

2,99,285,998

out.csv (The file I want make by VB.net)

ID, PINA,PINB,PCS,PCS

1,100,200,450,999

2,99,285,300,998

my problem code :

Dim FileReader As StreamReader
Dim i As Integer = 0
Dim temp As String
For i = 0 To LstFiles.Items.Count - 1
FileReader = File.OpenText(LstFiles.Items.Item(i))
temp = FileReader.ReadToEnd
File.AppendAllText(SaveFileDialog1.FileName, temp)
Next



Please guide me.

Thanks a lot !

Continue reading...