Data manipulation

I need assitance in manipulating a file. The trailer row of a file is alsways incorrect for a file. The trailer row does not count the number of times a delimited character is being counted. e.g. The command "cut -f 2 -d, TEMPFILE | grep CHARACTER1 | wc -l" output is 38147 The command "cut -f 2 -d, TEMPFILE | grep CHARACTER2 | wc -l" output is 64966 Here is the output for tailing the last line of TEMPFILE: tail -1 TEMPFILE 001,9,MDBK,610,0038147,0064966,O,20070331,025200,P I need a perl script to be called in a ksh script to ensure and if neccessary overwrite the correct value in the trailer row. This should take less than 1/2 hr for someone to construct.