Geek Answers Handbook

Pars and deduction valuation reports and average values

I want to calculate:

  • common points (amount)
  • today's points (amount)
  • total points (average)
  • today's points (average)

I have no idea with bash scripts, except that I need to start with: #! / Bin / bash

here is a sample of my file

#file 14516 - 2011-01-26 19:01:00 EDT# user: xxxxxxxx@email.com / id(11451611) lastlogin: 1295896515 total_points: 11.76 / today: 5.21 gameid: 51 user: xxxxxxxx@email.com / id(11837327) lastlogin: 1293893041 total_points: 416.1 / today: 98.1 gameid: 49 user: xxxxxxxx@email.com / id(11451611) lastlogin: 1294917135 total_points: 1.76 / today: 0.21 gameid: 51
+7
source share
1 answer

You can use this:

 #!/bin/bash if [ ! -f $1 ]; then echo "File $1 not found" exit 1 fi number=$(grep total_points $1 | wc -l ) sumTotal=$(grep total_points $1 | awk '{sum+=$2} END { print sum }') sumToday=$(grep total_points $1 | awk '{sum+=$5} END { print sum }') echo "Total SUM: $sumTotal" echo -n "Total AVG: " echo "scale=5;$sumTotal/$number" | bc echo "Today SUM: $sumToday" echo -n "Today AVG: " echo "scale=5;$sumToday/$number" | bc

Then save the file, for example: script.sh

Change the permissions on the executable: chmod +x script.sh

Then run it: ./script.sh sample.txt

This will output:

 Total Record: 3 Total SUM: 429.62 Total AVG: 143.20666 Today SUM: 103.52 Today AVG: 34.50666

Note: $1 will be the input file.

Here's some more help on the bc , grep , awk command

+7
source

More articles:


All Articles