Hi,

I am a nw bie to Schell Scripting, i have a same king of requirement as posted above.

my input file is also a log file as below.....

28.05.2008 07:02:56,105 [<anonymous>, NETB/CHG20931-5,NETB] INFO [] [ValidationTimeMeasurer] Validation request recieved

28.05.2008 07:03:57,856 [<anonymous>, NETB/CHG20931-5,NETB] INFO [] [ValidationTimeMeasurer] 0:01:13.998 Response sent with: <?xml version="1.0" encoding="ISO-8859-1"?>

<OMSMessage Version="">

<OMSTransport>

<CorrelationData>

<dispatcher>

<systemId>NETB</systemId>

<userId>sNetBusine</userId>

<supplierCode>NETB</supplierCode>

</dispatcher>

<supplierIdentifier>NETB/CHG20931-5</supplierIdentifier>

</CorrelationData>

</OMSTransport>

<OMSMessageHeader>

<Response/>

<Key>OMS</Key>

</OMSMessageHeader>

<OMSMessageBody>

<CreateProcessInstance.Response>

<Validation>Sucessfull</Validation>

</CreateProcessInstance.Response>

</OMSMessageBody>

</OMSMessage>

and my requirement is to extract 5 Columns for the below pattern of files to excel sheet.

Starttime - 28.05.2008 07:02:56,105

Information - <anonymous>, NETB/CHG20931-5,NETB(With this combination)

EndTime - 28.05.2008 07:03:57,856

Difference- 0:01:13.998

Information - xmlinfo

may i know how to write a Shell Script to do this,,,,,, Any help regarding this would be appreciable..........


Thanks & Best Regards,
Balaji Gopalakrishnan