Hi, I am trying split data from a CSV file, the function split mainly work for delimiter like comma, the data I have is like the below, no delimiter at all
Type
Status
Engagement analyst
OMSC003 - Basic content updates
CMS Approval Requested
James,Howard (New York)
OMSC027 - Create/change domain or subdomain
Open
Terry, Holly (Washington)
The function I am using is like the below, the result is like the data didn't go to each column in sql server, squeezed in one column.
DataTable tblcsv = new DataTable();
...
Go to the complete details ...