Search Results

Dear ygemici,
Can you explain what awk is doing.

Thanks in Advance.
Regards,
Ajay

Just write after read statement
/usr/bin/sed 's/$TYPE/'$TYPE'/' file2 > file3 and then you can [cat]/print the file.

/usr/xpg4/bin/awk -F" " '{
if (NR ==2)
{print $1 " " $2}
}' filename


This code will give output as below
SYSTEM SYSTEM
quarantine quarantine
nigel Nigel...

what will be the format of temperature file.

First Check for your sql file whether it is running properly or not and second thing if it is not printing echo 'Hi' written after ECHO then how the control is coming to grep stmt.

/usr/xpg4/bin/awk 'BEGIN{t1="";t2="";t3="";}{if($0 ~ /Buy/) t1=$4 }{if($0 ~ /Sell/) t2=$4}{if ($0 ~ /Server/) t3=$2} END{prin
t t1,t2,t3}' file1


You will get output as below
175 212 sepo2

Thanks man but one query that only print is a default command or any thing else?

Thanks methyl for making all points clear, Really appreciate.

Hi Rad,
I am new to awk,
Pls tell me what does mean by 1 at end in your code

echo 1 2 3 4 5 6 | /usr/xpg4/bin/awk '{if( NF > 2) { $3 = RS $3}}1'

Instead read $input try read input.

/usr/xpg4/bin/awk 'BEGIN {t1="";t2="";t3="";t4="";}
{ if ($1 ~ /TJ/ && $2 ~ /DETY/ ) { t1=$1; t2=$2; next; } }
{ if ($3 ~ /SP/) { t3=$3; next; } }
{ if($1 ~ /MGG/) { t4=$1; next; } }
{ if($1 ~...

I don't seem to understand the requirement too,
if you want to trim the white space characters at the end of each line, just enable trimspool:

set trimspool on

Sorry man, But I think you have not understand my prob properly.
Let me explain u.
I have already set the lin size as 500 so what ever line is coming from table they all have same lenght as 500...

This will give 0 0 0 only.substr is required.

Use below code

awk ' BEGIN {toth=0;totm=0;tots=0;}{
toth=toth+substr($2,1,2);
totm=totm+substr($3,1,2);
tots=tots+substr($4,1,2);}
END{print "Total Hours : " toth ;
print "Total Min : " totm...

Thanks for reply, but this is not working and giving same output.

Hi ,
I have inserted some records in a table having column "value1 varchar2(4000)" and want to spool in a file.
I have written as below

set echo off
set feed off
set hea off
set wra off
set...