Shell Programming and Scripting

Hi Chubler,

Just received your message and will try this tomorrow at work.. I saw that FILENAME and after reading about it knew it would be applied some where some how.

thanks

I will let you know how it comes out.

regards
al

---------- Post updated 01-27-15 at 08:49 AM ---------- Previous update was 01-26-15 at 07:03 PM ----------

Good Morning Chubler,

Just a note to say "THANKS!" for your help in this effort. The suggestion worked as it was supposed to without changing awk to nawk. Your effort will all me to create the metric now on a spread sheet tracking those databases that are having connections refused on a daily basis via server. In the string is the db name I change the names to protect the innocent as they say. I can say though it was a Navy program that you had a hand in helping keeping our servicemen/women paid on time and ships in good repair.

Again thanks,

al

---------- Post updated at 11:32 AM ---------- Previous update was at 08:49 AM ----------

Morning Chubler,

Just a quick question. I was trying to understand a section of the code and can't seem to find any information on it.

{F++} END{ if(F) print FILENAME":"F}

Can you briefly explain the F++ and the F means in this code? Can you recommend a good book to read on learning this subject?

It would be appreciated.

thanks

al

You are most welcome. Glad to hear the updated program is making your life easier.

I'll try and explain that code segment.

Firstly F has now special meaning and I picked the variable F to represent "Found". It's quite common here to use short variable names but for you own benefit later down the track I'd suggest using LinesFound or something like that.

F++ Has it's roots in the C programming language it increments the variable and could be also written as F=F+1 in basic and many other languages. Note if F is uninitialized (as in on the first matching line) it will be set to 1 by this command.

END{ if(F) print FILENAME":"F} The END condition is a special awk condition and only applies once after the all files have been processed. In this block we are testing our F variable and if it is non-zero we print the input file name followed by a colon character ":" and the F variable's value. This is to avoid printing "filename:" when no lines are found.

Morning,

I will put your explanation in my note book.

That is what I was surmising but wasn't sure. I am some what familiar with programming but never really had a chance to get my head into it. It was great working with you.

Regards

al