"" data with comma into one col while csv to datatable

Question

I am uploading .csv file & in that file I have 1 column which includes comma in the data. How to insert double quote ("") data with comma into one column while CSV file to datatable using in C# ? e.g. "aaa,bbb,ccc" is considered as 1 column while converting to datatable.

Piyush Pansuriya · Answer

You can do another way using "|" sign. If you can create your row like : 1|abc|24/12/1991|"aaa,bbb,ccc"|M|Y Than you can split your row with "|" . i.e. strdata.Split( '|' );

Faisal Pathan · Answer

try this var rows = row; while (rows.Contains( '"' )) { int Sindex = rows.IndexOf( """ ); string strF = rows.Substring(rows.IndexOf( """ ), rows.Length - rows.IndexOf( """ )); int Lindex = strF.IndexOf( """ , 1); var sub = rows.Substring(Sindex, Lindex + 1); var newsub = sub.Replace( "," , "&" ); newsub = newsub.Replace( """ , "" ); rows = rows.Replace(sub, newsub); rows = rows.Replace( "
" , "" ); } var cells = rows.Split( ',' ); string adviser = cells[0]; string client = cells[2]; var AccountNumber = cells[1]; .....

Sanket Jain · Answer

No, Not like that I have following data in my row : 1,abc,24/12/1991,"aaa,bbb,ccc",M,Y I am converting that row into datatable and that datatable saved into database thru Stored procedure.And I want to insert "aaa,bbb,ccc" as a single column in database.

Piyush Pansuriya · Answer

Hi, Do you need output like : "aaa" ,"bbb","ccc" ?

"" data with comma into one col while csv to datatable

Answers (4)