Shell Programming and Scripting

Hi All,

i am new to unix scripting,i need a help

Actually i want to take the count of two variables from a file.And i want to write that to another file.

can you please help me in this.

Post sample input and desired output.

INPUT FILE:

ACCOUNT NUMBER TEMPLATE DEL-CHNL TIMESTAMP
==============================================================
0000176576100033551 POSRSPS W 2010-09-08 03:15:04
0000176557100008322 POSNISPS W 2010-09-08 08:46:55
0000176557100025391 POSRRSLS F 2010-09-08 08:54:02
0000176576100033551 POSRSPS F 2010-09-08 09:10:01
0000176557100025045 POSRSPS F 2010-09-08 09:18:56
0000176557100020889 POSNISPS W 2010-09-08 09:20:05
0000176557100025425 POSNISPS W 2010-09-08 09:28:28


Here W and F are two variables

i want to take the count of these

W means pdf
F means pcl

output:

total pdf = w count
total pcl = f count

total = w+f count

Input file is a large file

Code:

awk '{a[$3]++};END{print "total pdf = "a["W"]"\nprint total pcl = "a["F"]"\ntotal = "a["W"]+a["F"]}' file

hi

First of tahnks for your quick repy.

my output is an another file and the format of that is

summary
...............................................................

pdf = w
pcl = f

..........................

total = w + f

---------- Post updated at 02:40 AM ---------- Previous update was at 02:26 AM ----------

hi

Actually we are running a real time application,and data is coming in MQ.
So when ever we get some data in MQ,our engine in unix will be creating output for that
particular file.And we are getting a detail report once the engine is processed.The egine is up for 23.45 hours.But it will come down for 15 min.At that time we want the count of the these two files.So can you please help me in this.

bartus11's code is fine, small adjusts for new look.

Code:

awk '
NR>2{a[$3]++}
END{ 
         print "summary\n..............................................................."
         print "total pdf = "a["W"]"\ntotal pcl = "a["F"]
         print "..........................\ntotal = "a["W"]+a["F"]
       }
' infile  >> outfile

put the command in cronjob ,and run it at engine down time.

hi thanks

but one more this that we are running in sun OS,

all the files is coming in this dir

/dartprod01/glob/logs/exstream/

we are having the detail report with the timestamp
crsd001_vhdcap2m_DETRPT.TXT.091410:031508
crsd001_phdcap2m_DETRPT.TXT.091410:031508

this summary script look in to the following files
and we need to get seperate summary like
crsd001_vhdcap2m_SUMMARY.TXT.091410:031508
crsd001_vhdcap2m_SUMMARY.TXT.091410:031508

you know we are getting detail report when ever data is present in MQ
But we have to look into the last detail report,ie just before 3.15
how we can implement this.