05-28-2008
1,
0
Join Date: May 2008
Last Activity: 29 May 2008, 9:13 AM EDT
Posts: 1
Thanks Given: 0
Thanked 0 Times in 0 Posts
Please Help me with this ..High Priority!
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