File Row Line Count without Header Footer


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers File Row Line Count without Header Footer
# 1  
Old 05-02-2013
File Row Line Count without Header Footer

Hi There!

I am saving the file count of all files in a directory to an output file using:

wc -l * > FileCount.txt

I get:

114 G4SXORD
3 G4SXORH
0 G4SXORP
117 total

But this count includes header and footer. I want to subtract 2 from the count and get

112 G4SXORD
1 G4SXORH
0 G4SXORP
113 total

Is there a way to do that in a one-liner? How do I subtract 2 from wc -l output before writing it to output file?

Thanks
# 2  
Old 05-02-2013
awk is great for simple off-the-cuff things like this. Testing on a bunch of 3-line files:

Code:
wc -l * | awk '$2=="total" { $1-=A; print ; next } { $1-=2; A+=2; print }'

1 a1c
1 a2c
1 a3c
1 a4c
4 total

$

For lines with 'total' in them, it subtracts the A variable from the first column, prints, and skips to the next line.

Otherwise, it skips that and executes the next section, which subtracts 2 from the first column, adds 2 to the A variable, then prints.
# 3  
Old 05-02-2013
try this one !
wc -l file | awk '{print $1-2}'

it gives number lines-2

---------- Post updated at 11:54 AM ---------- Previous update was at 11:54 AM ----------

try this one !
wc -l file | awk '{print $1-2}'

it gives number lines-2
# 4  
Old 05-02-2013
Another approach:
Code:
awk 'FNR==1{++c}END{print NR-(c*2) " total"}' *

# 5  
Old 05-02-2013
try this one !
Code:
wc -l * | awk '{print $1-2 " " $2}'

# 6  
Old 05-02-2013
Thanks what about 0?

Awesome Guys!

wc -l * | awk '{print $1-2 " " $2}'

and

wc -l * | awk '$2=="total" { $1-=A; print ; next } { $1-=2; A+=2; print }'

both work great

but what about 0 row count? It shows -2

Is it possible to include in there - if count < 0 then 0?

Thanks again!
# 7  
Old 05-02-2013
Code:
wc -l * | awk '!/total/{A[$2]=$1}/total/{for(k in A) {if(A[k]) s+=A[k]-2;print A[k]?A[k]-2:A[k],k} print s," total"}'

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Eliminate Header and footer from EBCDIC file

Is there any command to eliminate Header and footer from EBCDIC file (4 Replies)
Discussion started by: abhilashnair
4 Replies

2. Shell Programming and Scripting

Compare file1 header count with file2 line count

What I'm trying to accomplish. I receive a Header and Detail file for daily processing. The detail file comes first which holds data, the header is a receipt of the detail file and has the detail files record count. Before processing the detail file I would like to put a wrapper around another... (4 Replies)
Discussion started by: pone2332
4 Replies

3. Shell Programming and Scripting

Is there a way to append both at header and footer of a file

currently I've a file Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('024', '024', 2, sysdate); Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('032', '032', 2, sysdate); ........ is it... (3 Replies)
Discussion started by: jediwannabe
3 Replies

4. Shell Programming and Scripting

Removing header or footer from file

Hi Every one, what is the coomand to remove header or footer from a file. Please help me by providing command/syntax to remove header/footer from unix. Thanks in advance for all your support. (5 Replies)
Discussion started by: sridhardwh
5 Replies

5. Shell Programming and Scripting

Add header and footer with record count in footer

This is my file(Target.txt) name|age|locaction abc|23|del xyz|24|mum jkl|25|kol The file should be like this 1|03252012 1|name|age|location 2|abc|23|del 2|xyz|24|mum 2|jkl|25|kol 2|kkk|26|hyd 3|4 Column 1 is row indicator for row 1 and 2, column indicator is 1,for data rows... (1 Reply)
Discussion started by: itsranjan
1 Replies

6. Shell Programming and Scripting

sort a report file having header and footer

I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer. pls help (4 Replies)
Discussion started by: suryanarayana
4 Replies

7. Shell Programming and Scripting

Append Spaces At end of each line Leaving Header and Footer

How to append constant No of spaces suppose 52 at end of each line in a file (xyz) excluding first and last line. Please Help me out for the same. (1 Reply)
Discussion started by: deepam
1 Replies

8. Shell Programming and Scripting

Split large file and add header and footer to each file

I have one large file, after every 200 line i have to split the file and the add header and footer to each small file? It is possible to add different header and footer to each file? (1 Reply)
Discussion started by: ashish4422
1 Replies

9. Shell Programming and Scripting

Total of lines w/out header and footer incude for a file

I am trying to get a total number of tapes w/out headers or footers in a ERV file and append it to the file. For some reason I cannot get it to work. Any ideas? #!/bin/sh dat=`date +"%b%d_%Y"` + date +%b%d_%Y dat=Nov16_2006 tapemgr="/export/home/legato/tapemgr/rpts"... (1 Reply)
Discussion started by: gzs553
1 Replies

10. Shell Programming and Scripting

Need to Chop Header and Footer record from input file

Hi, I need to chope the header and footer record from an input file and make a new output file, please let me know how i can do it in unix.thanks. (4 Replies)
Discussion started by: coolbudy
4 Replies
Login or Register to Ask a Question