Hi!
I have made a windows forms application which I can open and modify csv files with.
I have an other program where the csv file is made with.
The problem is that the csv file has commas and double quotes as delimiters.
How can I trim the quotes so they dont appear in the datagridview?
Now it looks like this in my program.
And my code for the import looks like this:
- private void btnImport_Click(object sender, EventArgs e)
- {
- openFileDialog1.ShowDialog();
- txtFilePath.Text = openFileDialog1.FileName;
- BindDataCSV(txtFilePath.Text);
- }
- private void BindDataCSV(string filePath)
- {
- DataTable dt = new DataTable();
- string[] lines = System.IO.File.ReadAllLines(filePath);
- if (lines.Length > 0)
- {
- string firstLine = lines[0];
- string[] headerLabels = firstLine.Split(',');
- foreach (string headerWord in headerLabels)
- {
- dt.Columns.Add(new DataColumn(headerWord));
- }
- for (int r = 1; r < lines.Length; r++)
- {
- string[] dataWords = lines[r].Split(',');
- DataRow dr = dt.NewRow();
- int columnIndex = 0;
- foreach (string headerWord in headerLabels)
- {
- dr[headerWord] = dataWords[columnIndex++];
- }
- dt.Rows.Add(dr);
- }
- }
- if (dt.Rows.Count > 0)
- {
- dataGridView1.DataSource = dt;
- }
- }
I would really appreciate all help, Thanks
-Matti