CSV files
-
Hi experts, In my application, I do export data from datatable to csv file and import data from csv file. My problem is since csv file uses comma(,) as delimiter it splits text data with comma as two columns. Ur suggestions r highly appreciated.
-
Hi experts, In my application, I do export data from datatable to csv file and import data from csv file. My problem is since csv file uses comma(,) as delimiter it splits text data with comma as two columns. Ur suggestions r highly appreciated.
As you said, when you export/import data from the application, comma is specified as delimiter by default. Why don't you change the delimiter to some other charaters like ~ or # for export/import functionality?
-
Hi experts, In my application, I do export data from datatable to csv file and import data from csv file. My problem is since csv file uses comma(,) as delimiter it splits text data with comma as two columns. Ur suggestions r highly appreciated.
Put string with comma in Quotations...
"this, is , a , test",dataJust like this. :thumbsup::thumbsup:Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.