Member1

Member1

  • 1.9k
  • 169
  • 39.1k

How to read csv file vertically?

Apr 14 2015 2:47 AM
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 
 
 
 
 
 

Answers (3)