Hello all,
I have a text file as below which i need to convert to excel ...
ID=ANALOG2:TIC3601, PD=REACTOR 1 JACKET TEMP CONTROLLER, DB=1, SR=10,
RC=216;
ID=ANALOG2:TIC3601, PD=REACTOR 2 JACKET TEMP CONTROLLER, DB=2, SR=20,
RC=216;
ID=ANALOG2:TIC3601, PD=REACTOR 1 CORE TEMP CONTROLLER, DB=2, SR=30,
RC=216;
ID=ANALOG2:TIC3601, PD=REACTOR 2 CORE TEMP CONTROLLER, DB=1, SR=10,
RC=216;

It should look like this in excel with columnwise with header,is there
a code please help
ID PD DB SR RC
ANALOG2:TIC3601 REACTOR 1 JACKET TEMP CONTROLLER 1 10 216
ANALOG2:TIC3601 REACTOR 2 JACKET TEMP CONTROLLER 2 30 216
ANALOG2:TIC3601 REACTOR 1 CORE TEMP CONTROLLER 2 30 216
ANALOG2:TIC3601 REACTOR 2 CORE TEMP CONTROLLER 1 10 216

Thanks

A.kumar