How to print more than online using awk Post: 302077422

Sponsored Content

Top Forums Shell Programming and Scripting How to print more than online using awk Post 302077422 by newlearner on Thursday 22nd of June 2006 03:16:48 AM

06-22-2006

Registered User

How to print more than online using awk

Would you please help me on formatting the following lines of information.

Input file:
-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.000 [ one line only]
select emp_no, dept_no
from emp
where empname like 'Rob%'
;

-- appl = host = user = / pid = 76 elapsed = 0.000 seconds server_elapsed = 0.999 [ one line only]
select emp_no, dept_no
from dept
where deptname like 'IT%'
;

Output need to have all lines where server_elapsed >0.100 like below
server_elapsed=0.999 |select emp_no, dept_no from dept where deptname like 'IT%' ; [One line only]

newlearner

View Public Profile for newlearner

Find all posts by newlearner

5 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Is there online help for awk programming

Can anybody please supply me with a good url to get online help to awk programming, with good examples. Yes I've taken that big step in trying to master 'awk' after being able to avoid it for the last couple of years :-) Failing that, is there any good books I can get instead. Many thanks...

2. Shell Programming and Scripting

How do I get awk to print a " in it's print part?

The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }' I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ". Thanks.

3. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt...

4. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152...

5. UNIX for Dummies Questions & Answers

awk online to exclude rows

Hello, I have 3 columns like shown below: 1 1800 1900 2 1765 1900 3 1654 2054 4 1326 1499 5 1540 1765 I want only those rows where column 2 and column 3's values don't fall within 1800-1900 both inclusive. My output should only be: 4 1326 1499 5 1540 1765 Is there a quick awk...

LEARN ABOUT LINUX

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)