The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Conditonal clause in expect. akbar Shell Programming and Scripting 1 05-13-2008 04:28 PM
if clause palmer18 UNIX for Dummies Questions & Answers 3 08-08-2007 06:22 AM
building a SET clause in shell script shalua Shell Programming and Scripting 14 04-10-2007 03:34 PM
why put double square brackets in an if clause? napolayan UNIX for Dummies Questions & Answers 5 11-15-2006 11:18 PM
GROUP BY clause functionality in a C Program avdtech High Level Programming 2 03-08-2005 06:40 PM

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-21-2006
Registered User
 

Join Date: Mar 2006
Posts: 19
if clause in AWK END block not working.

Hello all...
I have a slight problem in my awk script...

I have a script which checks a csv file and keeps a count of any invalid records and then if it finds any, exits with a code of 1. problem is it dosnt seem to work properly Everthing seem to work interms of the stats output, but if clause in the END block dosnt seem to work? any ideas would be greatly appreciated!

Kind Regards

Satnam

awk -F, -v invalid_rec_count=0 ' { if (NF!=field_count) {
invalid_rec_count+=1 ;
if (invalid_rec_count<=max_spool) {
print $1;
}
}
}
#END { printf "%-10s\t\n","Total Lines["NR"]" ; if (invalid_rec_count=5) { "App error" ; exit 1 ;} }
END { printf "%-10s\t\n%-10s\t\n","Total Lines["NR"]","Invalid["invalid_rec_count"]" ; if (invalid_rec_count=5) { exit 1 } }

' max_spool="$bad_file_max_spool" field_count="$FIELD_COUNT" $data_dir_and_file
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 04-21-2006
Registered User
 

Join Date: Mar 2006
Posts: 19
Please ignore. problem solved. My mistake!

Please ignore. problem solved. My mistake! Me being silly!
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 08:57 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0