08-15-2007
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[count]=NR
counter++
}
END {
print "Total of:" count " rows."
for (i in list) {
print "Row: " list[i] ## Here, also print the actual row with linenr:list[i].
}
}
' infile.txt
Any help would be much appreciated.
//Bugenhagen
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file made of different blocks separated by blank lines. I need to print the blocks with odd indexes. How can I get it with awk?
For example i need to print the first and the third block of a file like this:
asgdg sadsd ssgsdgd
ass uff fedd sddddso
ieeduydd dddee deeo
ssancnc... (4 Replies)
Discussion started by: littleboyblu
4 Replies
2. Shell Programming and Scripting
I need to print specific lines from a file, say 2-5, 8, 12-15, 17, 19, 21-27. How do I achieve this? (2 Replies)
Discussion started by: Ilja
2 Replies
3. Shell Programming and Scripting
abc.dat
tty cpu
tin tout us sy wt id
0 0 7 3 19 71
extended device statistics
r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device
0.0 133.2 0.0 682.9 0.0 1.0 0.0 7.2 0 79 c1t0d0
0.2 180.4 0.1 5471.2 3.0 2.8 16.4 15.6 15 52 aaaaaa1-xx
I want to skip first 5 line... (4 Replies)
Discussion started by: kchinnam
4 Replies
4. Shell Programming and Scripting
Could someone please point me in the right direction with the following?
I have a program that generates logs that contains sections like this:
IMAGE INPUT
81 0 0.995 2449470 0 1726 368 1 0.0635 0.3291
82 0 1.001 2448013 0 1666 365 1 0.0649 ... (4 Replies)
Discussion started by: euval
4 Replies
5. Shell Programming and Scripting
Hi all
I have data like this:
model: 1, misfit value: 0.74987
1 1.182 1.735 2.056 1.867
2 0.503 1.843 2.018 1.888
3 2.706 2.952 2.979 1.882
4 8.015 3.414 3.675 1.874
... (1 Reply)
Discussion started by: fedora2011
1 Replies
6. Shell Programming and Scripting
Hello all,
I have thousand file input like this:
file1:
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$ | | | |$$
$$ UERT | TTYH | TAFE | FRFG |$$
$$______|______|________|______|$$
$$ | | | |$$
$$ 1 | DISK | TR1311 | 1 |$$
$$ 1 |... (4 Replies)
Discussion started by: attila
4 Replies
7. Shell Programming and Scripting
Hi,
Please have a look on below records.
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: The value of the row is: EMPLID = 220677 COMPANY = 919 BALANCE_ID = 0 BALANCE_YEAR = 2012
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated
... (4 Replies)
Discussion started by: Sachin Lakka
4 Replies
8. Shell Programming and Scripting
Hello,
i need help with awk.
I have this file:
cat number
DirB port 67 er_enc_out 0 er_bad_os 0
DirB port 71 er_enc_out 56 er_bad_os 0
DirB port 74 er_enc_out 0 er_bad_os 0
DirB port 75 ... (4 Replies)
Discussion started by: elilmal
4 Replies
9. Shell Programming and Scripting
I need to print specific lines 5,100,67,123 in a file.
file name: today.csv (3 Replies)
Discussion started by: ramkumar15
3 Replies
10. UNIX for Beginners Questions & Answers
Hi, I need to print lines which are matching with start pattern "SELECT" and END PATTERN ";" and only select the last "select" statement including the ";" .
I have attached sample input file and the desired input should be as:
INPUT FORMAT:
SELECT
ABCD,
DEFGH,
DFGHJ,
JKLMN,
AXCVB,... (5 Replies)
Discussion started by: nani2019
5 Replies
MOVE(7) PostgreSQL 9.2.7 Documentation MOVE(7)
NAME
MOVE - position a cursor
SYNOPSIS
MOVE [ direction [ FROM | IN ] ] cursor_name
where direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE count
count
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL
DESCRIPTION
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and
does not return rows.
The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH(7) for details on syntax and usage.
OUTPUTS
On successful completion, a MOVE command returns a command tag of the form
MOVE count
The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
EXAMPLES
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5
-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
code | title | did | date_prod | kind | len
-------+--------+-----+------------+--------+-------
P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)
-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
COMPATIBILITY
There is no MOVE statement in the SQL standard.
SEE ALSO
CLOSE(7), DECLARE(7), FETCH(7)
PostgreSQL 9.2.7 2014-02-17 MOVE(7)