Print filename and last line using awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print filename and last line using awk
# 1  
Old 11-02-2012
Print filename and last line using awk

Hi,
using awk command I want to print filenames and the last line of each file, in a single command line statement.
I want to use 'awk', because I want to add more functionality to this logic later.

I tried the following on *.sh files in the current directory

Code:
find . -type f -name "*.sh" -exec awk 'NR = FNR {print FILENAME NR}' {} \;

but the above command prints all line numbers of every file and not just the last line
I understand that 'NR' stands for line number and not the line content itself

How can I print the filename, along with ONLY the last line (content) of the file?

Thanks,
-sri
# 2  
Old 11-02-2012
You could use something like this:

Code:
find . -type f -name "*.sh" -exec awk '{s=$0};END{print FILENAME,s}' {} \;

# 3  
Old 11-02-2012
Thanks Subbeh, it works !
Now, how can I print the filename and the last line of only those files where the last line is not like '' (empty) ?

In other words, I want list all filenames together with their last line where the file doesn't end with a new line

Thanks
-sri
# 4  
Old 11-02-2012
You can simply use this:

Code:
find . -type f -name "*.sh" -exec awk '{s=$0};END{if(s)print FILENAME,s}' {} \;

# 5  
Old 11-02-2012
... or simply

Code:
 find . -type f -name "*.sh" -exec awk 'END{if ($0) print FILENAME,$0}' {} \;


Last edited by ripat; 11-02-2012 at 09:56 AM..
# 6  
Old 11-02-2012
Quote:
Originally Posted by ripat
... or simply

Code:
... awk 'END{if ($0) print FILENAME,$0}' {} \;

AWK is not required to preserve the value of the field variables ($0, $1, etc...) for the END section and some implementations don't. Subbeh's approach is the safest, most portable solution.

Regards,
Alister
# 7  
Old 11-02-2012
Quote:
Originally Posted by alister
AWK is not required to preserve the value of the field variables ($0, $1, etc...) for the END section and some implementations don't. Subbeh's approach is the safest, most portable solution.
Works with the original awk, mawk, nawk, gawk and gawk in its traditionnal mode. If OP needs to process big files, it's about two times faster.

See also http://awk.info/?awk1line
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk to print filename words along with delimiter

Hi, I have filename as: 010020001_S-FOR-Sort-SYEXC_20180109_062320_0100.x937 I need first 5 words of my filename along with the respective delimiters: I tried this: f=010020001_S-FOR-Sort-SYEXC_20180109_062320_0100.x937 echo $f | awk -F '' '{print $1$2$3$4$5}' 010020001SFORSortSYEXC ... (11 Replies)
Discussion started by: gnnsprapa
11 Replies

2. Shell Programming and Scripting

Use while loop to read file and use ${file} for both filename input into awk and as string to print

I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix. I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice. Files:... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

3. Shell Programming and Scripting

awk to print the line that matches and the next if line is wrapped

I have a file and when I match the word "initiators" in the first column I need to be able to print the rest of the columns in that row. This is fine for the most part but on occasion the "initiators" line gets wrapped to the next line. Here is a sample of the file. caw-enabled ... (3 Replies)
Discussion started by: kieranfoley
3 Replies

4. UNIX for Advanced & Expert Users

Problem piping find output to awk, 1st line filename is truncated, other lines are fine.

Today I needed to take a look through a load of large backup files, so I wrote the following line to find them, order them by size, and print the file sizes in GB along with the filename. What happened was odd, the output was all as expected except for the first output line which had the filename... (4 Replies)
Discussion started by: gencon
4 Replies

5. Shell Programming and Scripting

awk script -print line when $2 > $2 of previous line

Hi all, From a while loop I am reading a sorted file where I want to print only the lines that have $1 match and $2 only when the difference from $2 from the previous line is > 30. Input would be like ... AN237 010 193019 0502 1 CSU Amoxycillin AN237 080 ... (2 Replies)
Discussion started by: gafoleyo73
2 Replies

6. Shell Programming and Scripting

Print filename with awk

I can got the filename with this script. it's only show "-" in result. cut -d , -f7 CSV_d.* | awk 'OFS=":"{print FILENAME,substr($1,1,8),substr($1,9,2),substr($1,11,2),substr($1,13,2)}' | sort |uniq (2 Replies)
Discussion started by: before4
2 Replies

7. Shell Programming and Scripting

awk to print on the same line

Hi all, I've a script that uses awk to parse the output of wget during a database update. The code I use is: wget -c ftp://ftpsite/file 2>&1 | awk '/0%/ {print}'But this spits out each progress line on a new line: 37250K .......... .......... .......... .......... .......... 80% 10.9M 1s ... (2 Replies)
Discussion started by: euval
2 Replies

8. Shell Programming and Scripting

Howto Print File Path or Print the Filename

I'm trying to clean up my samba share and need to print the found file or print the path of the image it tried to searched for. So far I have this but can't seem to get the logic right. Can anyone help point me in the right direction? for FILE in `cat list`; do if ; then ... (1 Reply)
Discussion started by: overkill
1 Replies

9. Shell Programming and Scripting

awk print the next line on the current line

Ok I have a file with hundreds of lines, four columns, space delimited, TESTB.TXT for example TESTB.TXT --- AA ZZ 12 34 BB YY 56 78 CC XX 91 23 DD VV 45 67 --- I want a new file that has 7 columns, the first four are identical, and the next 3 are the last three of the next line...so... (5 Replies)
Discussion started by: ajp7701
5 Replies

10. Shell Programming and Scripting

print any required line by its line no using awk and its NR variable

how to print any required line by its line no using awk and its NR variable for eg: ------------ 121343 adfdafd 21213sds dafadfe432 adf.adf%adf --------------- requied o/p if give num=3 it print: 21213sds -------------------------------------- (2 Replies)
Discussion started by: RahulJoshi
2 Replies
Login or Register to Ask a Question