1 Attachment(s)
How to combined multiple csv files into new csv file using DOS command?
In DOS Command I can combined multiple .csv file using this code.
Code:
COPY *.csv NewCSVFile.csv
Attachment 134211
I just write some code bt i dont know how to execute above command inside vb.net
Code:
Imports System.Windows.Forms
Imports System.IO
Public Class CombineCSV
Private Sub btnBrowse_Click(sender As Object, e As EventArgs) Handles btnBrowse.Click
If (LocateCSVFolder.ShowDialog() = DialogResult.OK) Then
txtLocateCSV.Text = LocateCSVFolder.SelectedPath
End If
End Sub
Private Sub btnNewCSVLocation_Click(sender As Object, e As EventArgs) Handles btnNewCSVLocation.Click
If (LocateCSVFolder.ShowDialog() = Windows.Forms.DialogResult.OK) Then
txtNewCSVLocation.Text = LocateCSVFolder.SelectedPath
End If
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim xLocation As String
Dim xNewLocation As String
Dim xNewFileName As String
xLocation = txtLocateCSV.Text 'Directory of csv files
xNewLocation = txtNewCSVLocation.Text 'Directory of combined CSV
xNewFileName = txtNewCSV.Text 'New Filename for combined csv ex. School_Details.csv
'in dos i can do
'copy xlocation\*.csv xNewlocation\xNewfileName
End Sub
End Class
Thanks for your time.
Re: How to combined multiple csv files into new csv file using DOS command?
any idea bout how its done?