3 Dec
2009
3 Dec
'09
4:16 a.m.
From: mark m.roth@5-cent.us
John Doe wrote:
From: hadi motamedi
Can you please do me favor and let me know if I can go further and try for advanced search like finding how many rows inside a file have data that does not start with a zero after the third comma ?
Something like: awk -F, ' { print $4 } ' | grep -v "^0" | wc -l Use one command at a time to see how they work with each other (you might have to modify the grep a bit)...
*sigh*
Drive me crazy, why use multiple commands?
awk -F 'BEGIN { FS = ","; }{if ( $3 !~ /^0 ) { count++; }} END { print count }' filename
Oh no!!! Don't get mad!!! ^_^ Teaching some UNIX pipes to a "beginner" can be helpful you know... And it is $4...
JD