Shell Script for copying text file to Excel Sheet

Shell Programming and Scripting
1

Hi,
I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time.
I want to pick these info from text file and put it in excel sheet.

here is how the text file looks -

04.17.2014 08:06:12,697 Ik-asjkjantkLgrts.Log Response ABC
POST /login/methodName?Content-Type: text/xml { here it will have all details )

<response>
<header>
<Code>7787</statusCode>
<Desc>Here it will have code description</statusDesc>

</header>

</response>

Is this possible? Help will be appreciated.

2

Try to remove all xml tags and put your columns' values into one line, separated by semicolons. Then read/import that into EXCEL as a .csv file.