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

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. 

try this 

 

 

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.

Hi,

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