topic Re: awk help and shell script in Operating System - HP-UX

awk help and shell script

kholikt — Thu, 11 Dec 2003 02:28:19 GMT

I have a shell script to extract some omniback report

I wish to remove some of the column.

QAS Completed trans 12/11/03 05:00:06 1071090006 12/11/03 05:04:07 1071090247 0:00 0:04 0.37 1 0 3 0 0 0 4 4 4 100% root.sys@cm.esc 2003/12/11-14

In my shell script
cat $DESTDIR/ses.final | while read LINE
do
LINE2=`echo $LINE | awk '{print $1 $2 $3}'`
done

Is it possible to put \t (tab) in between $1 $2 & $3

Re: awk help and shell script

Jean-Louis Phelix — Thu, 11 Dec 2003 02:35:46 GMT

Hi,

You just need to use printf instead of print :

LINE2=`echo $LINE | awk '{printf "%s\t%s\t%s\n", $1, $2, $3}'`

Regards.

Re: awk help and shell script

Sanjay_6 — Thu, 11 Dec 2003 02:40:28 GMT

Hi,

Try

LINE2=`echo $LINE | awk '{print $1,"\011",$2,"\011",$3}'`

Hope this helps.

Regds

Re: awk help and shell script

Sanjay_6 — Thu, 11 Dec 2003 02:47:02 GMT

Hi,

you can use the \t suggested by Jean with the print command also.

LINE2=`echo $LINE | awk '{print $1,"\t",$2,"\t",$3}'`

hope this helps.

Regds

Re: awk help and shell script

Graham Cameron_1 — Thu, 11 Dec 2003 03:31:07 GMT

No need to use cat while read, you can do the whole thing with awk...

awk '
{printf ("%s\t%s\t%s\n", $1, $2, $3)}
' $DESTDIR/ses.final

-- Graham

Re: awk help and shell script

curt larson_1 — Thu, 11 Dec 2003 10:13:31 GMT

or just do it all in the shell

cat $DESTDIR/ses.final |
while read var1 var2 var3
do
print "$var1\t$var2\t$var3"
done