awk print lines in a file Post: 302545220

Sponsored Content

Top Forums Shell Programming and Scripting awk print lines in a file Post 302545220 by yoavbe on Sunday 7th of August 2011 01:38:15 PM

08-07-2011

Registered User

AWK question

Hi,
I have a file look likes this :

--->start hir
Trace file: pudwh_ora_9998.trc
Sort options: fchela exeela
***************************************************************count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
***************************************************************
CREATE TABLE UAC_37662_ga NOLOGGING AS SELECT DISTINCT
CRM.CI_CUST_INFO.NAP_INT_CUST_NUM FROM CRM.CI_CUST_INFO WHERE
CRM.CI_CUST_INFO.LAST_MIV_STATUS_PAC_DECSR IN ( 'פעיל' )

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 18.31 239.91 326 4999384 631 368776
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 18.31 239.91 326 4999384 631 368776

Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 94
***************************************************************
SELECT NAP_INT_CUST_NUM
FROM
UAC_37662_ga ORDER BY NAP_INT_CUST_NUM

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 74 0.51 0.59 0 155 0 368776
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 76 0.51 0.59 0 155 0 368776

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 94
....
---> End hir

I would like to print only the following output :

elapsed
----------
0.00
239.91
0.00
----------
239.91

elapsed
----------
0.00
0.00
0.59
----------
0.59

I tryied :

cat filename.txt | awk '{print $4} '
But its not enough since i get all the output under column 4.

Thanks

yoavbe

View Public Profile for yoavbe

Find all posts by yoavbe

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to print number of lines with awk ?

Can some body tell me how to print number of line from a particular file, with sed. ? Input file format AAAA BBBB CCCC SDFFF DDDD DDDD Command to print line 2 and 3 ? BBBB CCCC And also please tell me how to assign column sum to variable. I user the following command it...

2. Shell Programming and Scripting

How to print specific lines with awk

Hi! How can I print out a specific range of rows, like "cat file | awk NR==5,NR==9", but in the END-statement? I have a small awk-script that finds specific rows in a file and saves the line number in an array, like this: awk ' BEGIN { count=0} /ZZZZ/ { list=NR ...

3. Shell Programming and Scripting

Print lines matching value(s) in other file using awk

Hi, I have two comma separated files. I would like to see field 1 value of File1 exact match in field 2 of File2. If the value matches, then it should print matched lines from File2. I have achieved the results using cut, paste and egrep -f but I would like to use awk as it is efficient way and...

4. UNIX for Dummies Questions & Answers

Awk print all lines on match?

Ok so I can use awk to match a pattern and print the whole line with print $0. Is there any way to just tell awk to print every line of output when the pattern matches? I'm having it wait for the word error and then print that entire line. But what I actually need to see is all the following...

5. Shell Programming and Scripting

grep/awk to only print lines with two columns in a file

Hey, Need some help for command to print only lines with two columns in a file abc 111 cde 222 fgh ijk 2 klm 12 23 nop want the ouput to be abc 111 cde 222 ijk 2 Thanks a lot in advance!!!

6. Shell Programming and Scripting

AWK and print next lines #3 thru #10

I have a output log file, that I want to extract some temperature measurement data. I want to AWK on the words "show chassis environment" in the original file, and extract that entire line, and then the 3rd to 10th lines after the one I AWK'd, into a seperate output file. Here is an example...

7. UNIX for Dummies Questions & Answers

awk - (URGENT!) Print lines sort and move lines if match found

URGENT HELP IS NEEDED!! I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. - Also the matching lines are not moving out of File1.txt ...

8. Shell Programming and Scripting

Print all lines in a row except the last one with awk

Hi again, is it possible to do the following using awk? input file is 4.465E+17 5.423E+16 1.218E+17 2.600E+16 9.135E+15 1.238E+14 ... 6.238E+14 desired output 4.465E+17 & 5.423E+16 & 1.218E+17 & 2.600E+16 & 9.135E+15 & 1.238E+14 & ... &

9. Shell Programming and Scripting

awk to print out lines that do not fall between range in file

In the awk below I am trying to print out those lines in file2 that are no between $2 and $3 in file1. Both files are tab-delimeted and I think it's close but currently it is printeing out the matches. The --- are not part of the files they are just to show what lines match or fall into the range...

10. Shell Programming and Scripting

awk to print lines that meet conditions and have value in another file

I am trying to use awk to print lines that satisfy either of the two conditions below: condition 1: $2 equals CNV and the split of $3, the value in red, is greater than or equal to 4. ---- this is a or so I think condition 2: $2 equals CNV and the split of $3, the value in red --- this is a...

LEARN ABOUT MOJAVE

iotop

iotop(1m)							   USER COMMANDS							 iotop(1m)

NAME

       iotop - display top disk I/O events by process. Uses DTrace.

SYNOPSIS

       iotop [-C] [-D|-o|-P] [-j|-Z] [-d device] [-f filename] [-m mount_point] [-t top] [interval [count]]

DESCRIPTION

       iotop tracks disk I/O by process, and prints a summary report that is refreshed every interval.

       This is measuring disk events that have made it past system caches.

       Since this uses DTrace, only users with root privileges can run this command.

OPTIONS

       -C     don't clear the screen

       -D     print delta times - elapsed, us

       -j     print project ID

       -o     print disk delta times, us

       -P     print %I/O (disk delta times)

       -Z     print zone ID

       -d device
	      instance name to snoop (eg, dad0)

       -f filename
	      full pathname of file to snoop

       -m mount_point
	      mountpoint for filesystem to snoop

       -t top print top number only

EXAMPLES

       Default output, print summary every 5 seconds
	      # iotop

       One second samples,
	      # iotop 1

       print %I/O (time based),
	      # iotop -P

       Snoop events on the root filesystem only,
	      # iotop -m /

       Print top 20 lines only,
	      # iotop -t 20

       Print 12 x 5 second samples, scrolling,
	      # iotop -C 5 12

FIELDS

       UID    user ID

       PID    process ID

       PPID   parent process ID

       PROJ   project ID

       ZONE   zone ID

       CMD    command name for the process

       DEVICE device name

       MAJ    device major number

       MIN    device minor number

       D      direction, Read or Write

       BYTES  total size of operations, bytes

       ELAPSED
	      total elapsed times from request to completion, us (this is the elapsed time from the disk request (strategy) to the disk completion
	      (iodone))

       DISKTIME
	      total times for disk to complete request, us (this is the time for the disk to complete that  event  since  it's	last  event  (time
	      between iodones), or, the time to the strategy if the disk had been idle)

       %I/O   percent disk I/O, based on time (DISKTIME)

       load   1 minute load average

       disk_r total disk read Kb for sample

       disk_w total disk write Kb for sample

DOCUMENTATION

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       iotop will run forever until Ctrl-C is hit, or the specified interval is reached.

AUTHOR

       Brendan Gregg [Sydney, Australia]

SEE ALSO

       iosnoop(1M), dtrace(1M)

version 0.75							   Oct 25, 2005 							 iotop(1m)