Add columns to an existing excel sheet

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi All,

i have an excel sheet as below:

day
-----
monday
tuesday
wenesday
thursday
friday

i need to append the two more columns in this existing file below:

insert date should be todays date---

day insert date insert user
---- ---------- -----------

monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun

please advise..

thanks in advance..
Arun Manas

2 
$ sed 's/.*/& sysdate arun/' test.txt
monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun

---------- Post updated at 09:28 PM ---------- Previous update was at 09:28 PM ----------

$ awk '{printf("%s sysdate arun\n",$0)}' test.txt
monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun

---------- Post updated at 09:29 PM ---------- Previous update was at 09:28 PM ----------

$ sed 's/$/ sysdate arun/' test.txt
monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun

---------- Post updated at 09:30 PM ---------- Previous update was at 09:29 PM ----------

$ while read line; do echo  "$line sysdate arun"; done < test.txt
monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun
3

Hi Kamraj,

Thanks for the reply..

in place of the sysdate, i need to display the current date...

Thanks in advance,
Arun Manas

4 
$ awk -v sysdate="`date`" '{printf("%s %s arun\n",$0,sysdate)}' test.txt
monday Thu Jul  7 00:37:43 SGT 2011 arun
tuesday Thu Jul  7 00:37:43 SGT 2011 arun
wednesday Thu Jul  7 00:37:43 SGT 2011 arun