I have to creating shell script for taking log report of my newly created sms server and by using awk grep and other command i got the following which satisfy our need


2009-12-22 13:30:33 Sender is ashu@xxxxsgroup.in
2009-12-22 13:30:33 Sending to 0xxxx283738
2009-12-22 13:30:38 status of message is ATZ
2009-12-22 13:30:38 Sending to 0xxxx8583685
2009-12-22 13:30:43 status of message is ATZ
2009-12-22 13:30:44 Sending to xxxx067998
2009-12-22 13:30:49 status of message is ATZ
2009-12-22 13:38:22 Sender is ashu@xxxxxsgroup.in
2009-12-22 13:38:22 Sending to xxxx83685
2009-12-22 13:38:27 status of message is ATZ
2009-12-22 15:06:57 Sender is user1@xxxxxxgroup.in
2009-12-22 15:06:57 Sending to 09958583685
2009-12-22 15:08:03 Sender is user1@xxxxxxgroup.in
2009-12-22 15:08:03 Sending to xxxxx8583685
2009-12-22 15:09:19 Sender is user1@xxxxxxgroup.in
2009-12-22 15:09:19 Sending to 0xxx8583685
2009-12-22 15:09:24 status of message is ATZ

but the thing is i want it to be in excel format that means like
the first three lines which has time date sender sending to and status in one line

and than other three in one line excluding 2 and 3 lines date and time because we already have by first line like eg.
this
2009-12-22 13:30:33 Sender is ashu@xxxxsgroup.in Sending to 0xxxx283738 status of message is ATZ


thanks in advanced

What have you thought of or tried so far?

You might get more replies with a more meaningful title (you can change it via Edit and "Go Advanced") like "bash: how to get data from log file?".

There have been many similar threads. Have you tried searching LQ using keywords like bash, shell, script, log, lines, read ... ?