split row problem when i cvs file import to mssql

Ekrem Tapan

11y1k.NET

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('\n'))

{

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

XXX","XXX","04011","XX","XX","XX, YY","N039","S040","A","20141003 18:54","20141003 20:18","20141003 23:18"

when importto red part my code is after , move to another cell

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted answer
Please find below code:

string csvData = File.ReadAllText(csvPath);
foreach (string row in csvData.Split('\n'))
{
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 Tapan11y ago
Manas Mohapatra hi,

i get it

thanks for your solution ;)
string csvData = File.ReadAllText(csvPath);
foreach (string row in csvData.Split('\n'))
{
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 Tapan11y ago
Manas Mohapatra hi,

can u write the code clearly ?
Manas Mohapatra11y ago
You can use below code to replace double quote:

string temp = cell.Replace("\"", "");
Ekrem Tapan11y ago
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 ?