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.

Perl

项目ID： #137472

关于项目