I tried lots in lots of ways but not reached to answer.
my question is i want to read csv file in the following format ....
ID=,10001,
Name=,Hemant Desai,
Age=,60,
Sex=,male,
Doctor=,Pathak,
Mobile=,9021412202,
Alignment=,brain toumer,
No of medicins=,3,
12:02,Stamlo-5,1mg,oral,after meal,*XE0280916*
12:01,Atorfit-CV-10,4mg,oral,after meal,*XE0283337*
12:01,Losar,3mg,oral,after meal,*XE0284350*
12:02,Appointment,X ray of right chest at 11.00 am on Wed 11th Dec
12:01,procedure,Sponge patient with warm water
Temperature =,222
Blood Pressure =, 555/555
Pulse Rate =, 555
Respiratory Rate =, 999
in this file the data is in all headers and its values are in vertical format which keep this hard to read and the data from((
No of medicins=,3,
12:02,Stamlo-5,1mg,oral,after meal,*XE0280916*
12:01,Atorfit-CV-10,4mg,oral,after meal,*XE0283337*
12:01,Losar,3mg,oral,after meal,*XE0284350*
12:02,Appointment,X ray of right chest at 11.00 am on Wed 11th Dec
12:01,procedure,Sponge patient with warm water
)) should be in one column No of Medicins . can not change format or remove quammas as this format is fixed.
and save this data in table "Medicin" as in respective columns as (((id , name , age , sex , doctor , allignment , no of medicin , temperature , blood pressure , pulse rate , respiratory rate ))).
plz help me
thanks in advance.
gd
Saber ShaikhPosted Apr 15, 2015, 2:48 AM
Refer it
My Blog
Member1Posted Apr 14, 2015, 4:30 AM
Ankur JainPosted Apr 14, 2015, 4:13 AM
Just came across this library: https://github.com/JoshClose/CsvHelper
Very intuitive and easy to use. Has a nuget package too which made is quick to implement:http://nuget.org/packages/CsvHelper/1.17.0. Also appears to be actively maintained which I like.
Configuring it to use a semi-colon is easy: https://github.com/JoshClose/CsvHelper/wiki/Custom-Configurations