split row problem when i cvs file import to mssql

Question

hi everyone i want to ask how can i split cvs file when i import to mssql my code is here string csvData = File.ReadAllText(csvPath); foreach (string row in csvData.Split('
')) { if (!string.IsNullOrEmpty(row)) { dt.Rows.Add(); int i = 0; foreach (string cell in row.Split('')) { dt.Rows[dt.Rows.Count-1][i] = cell; i++; } } } but my cvs file hava a this line XXXXXX04011XXXX XX YY N039S040A20141003 18:5420141003 20:1820141003 23:18 when importto red part my code is after  move to another cell

Manas Mohapatra · Answer

Please find below code: string csvData = File.ReadAllText(csvPath); foreach (string row in csvData.Split('
')) { if (!string.IsNullOrEmpty(row)) { dt.Rows.Add(); int i = 0; foreach (string cell in row. Split(new string[] {\} StringSplitOptions.None) ) { dt.Rows[dt.Rows.Count-1][i] = cell; i++; } } }

Ekrem Tapan · Answer

Manas Mohapatra hi i get it thanks for your solution ;) string csvData = File.ReadAllText(csvPath); foreach (string row in csvData.Split('
')) { if (!string.IsNullOrEmpty(row)) { dt.Rows.Add(); int i = 0; foreach (string cell in row.Split(new string[] { \ } StringSplitOptions.None)) { string temp = cell.Replace(\ ); dt.Rows[dt.Rows.Count - 1][i] = temp; i++; } } }

Ekrem Tapan · Answer

Manas Mohapatra hi can u write the code clearly ?

Manas Mohapatra · Answer

You can use below code to replace double quote: string temp = cell.Replace(\ );

Ekrem Tapan · Answer

Manas Mohapatra hi after use your code my output is col1 | col2 | col1 | col2 |  XX |  XXX |  04011 |  XX | now i have a more one  how can i remove this one ?