Shell Programming and Scripting

Hi all,

I am fairly new to UNIX and I was wondering if you could provide me with some help! Lets say i have a file as below :

Code:

Line 1  
Line 2 
Line 3 
ABC|12|4|2

Now the number 4 in bold, this number will represent the number of row there is in the file excluding the header and footer so the result should be 2.

So what i want to do it to write a code that counts the number of rows in the file in this case 4, minus it by 2 (because excluding header and footer), go to the last line, replace the third value seperated by the delimiter and save the file.

Currently i am running the code below:

Code:

awk 'BEGIN{FS=OFS="|"} END{$3=NR-2;print};1' $1

This is the output it get after running the code:

Code:

Line 1  
Line 2 
Line 3 
ABC|12|4|2
ABC|12|2|2

My desired output is :

Code:

Line 1  
Line 2 
Line 3 
ABC|12|2|2

then save it.

can someone help me please ? Hope that all makes sense.

Moderator's Comments:

Added code tags