UNIX for Dummies Questions & Answers

Hi,

I have a file containing the following data:

junk123junk723itemcode001qty01price10total10junkjunk
junk123junk723itemcode002qty02price10total20junkjunk
..
..
..
could be 5000+ lines

I have an algo and need a code to implement this:
1. Linecount = wc -l (should give 5000)
2. For i = 1 to linecount (loops 5000 times)
3. pick up the value from total and aggregate them ie 10 + 20 = 30
4. This should be done fr all the lines and the total aggregated total in a variable called TOTAL.
5. The total aggregate should be compared against a database query ie:

total_database=`sqlplus -s un/pw@TNS_NAME<<END
set pagesize 0
set feedback off
set heading off
set echo off
set verify off
select total from results;
exit;
END`
echo "$total_database"

If $ total_database = $TOTAL then pass, else echo fail..

Can someone kindly help me out with this.I hope I gave in enough info..

Thanks and Regards,
Ron.

assuming the total is always 2 digits.

Code:

# total=$(awk '{match($0,"total");c=c+substr($0,RSTART+5,2)}END{print c}' file)
# echo $total
30