## Calculate the total

Calculate the total
# 8
03-02-2014
Here I think a complete re-write is best:

Last edited by Chubler_XL; 03-02-2014 at 03:53 PM..
 Chubler_XL View Public Profile for Chubler_XL Find all posts by Chubler_XL
# 9
03-03-2014
thanks Chubler XL 's great job .

May be my question is still not clearly ,

what I would like to count is the number of the currence of the first string in file.txt , the file.txt is as below.
therefore , I would like to count the number of the string "aaa" and "bbb" in *.log , the "111" and "222" will be shown on the report only.

in aaaa201401.log , there are two "aaa" , two "bbb" ;
in aaaa201402.log , there are four "aaa" , five "bbb

the desired report should be as bwlow.

Last edited by ust3; 03-03-2014 at 02:35 AM..
 ust3 View Public Profile for ust3 Find all posts by ust3
# 10
03-03-2014
That output is what is produced by the code above, using your input files from post #1.

If this is wrong, please build new input files show the problem.
 Chubler_XL View Public Profile for Chubler_XL Find all posts by Chubler_XL
# 11
03-03-2014
I have re-buile a new log files , it should be more clear .
What I hope to do is to check how many the string ( "aaa" and "bbb" ) are occurence in each file .

#vi file.txt

#vi aaaa201401.log
#vi aaaa201402.log
in aaaa201401.log , there are two "aaa" , three "bbb" ;
in aaaa201402.log , there are four "aaa" , five "bbb

the desired report should be as below.
 ust3 View Public Profile for ust3 Find all posts by ust3
# 12
03-03-2014
If you have groff on your system this might be an easier way to print the ascii table:

Output:
---------- Post updated at 04:42 AM ---------- Previous update was at 03:29 AM ----------

If your using an xterm (or such) you could try groff -T utf8 instead of groff -T ascii:

Last edited by Chubler_XL; 03-03-2014 at 01:36 PM..
 Chubler_XL View Public Profile for Chubler_XL Find all posts by Chubler_XL
# 13
03-04-2014
Quote:
Originally Posted by Chubler_XL
If you have groff on your system this might be an easier way to print the ascii table:

Output:
---------- Post updated at 04:42 AM ---------- Previous update was at 03:29 AM ----------

If your using an xterm (or such) you could try groff -T utf8 instead of groff -T ascii:

Hi Chubler_XL ,

Very thanks for your work , I hope this is my last question .
If I would like to check the occurrence of the whole string "aaa" , the string "aaa" may not be begins and ended with space , for example , if the log is as below , it still count the occurrence of "aaa" is 2 , how to modify the script ? thanks

Last edited by ust3; 03-04-2014 at 10:22 PM..
 ust3 View Public Profile for ust3 Find all posts by ust3
# 14
03-04-2014
replace \$1==S{T++;C[f]++} with \$1~S{T++;C[f]++}
 Chubler_XL View Public Profile for Chubler_XL Find all posts by Chubler_XL

## Calculate total memory using free -m

Hi I am trying to calculate memory used by Linux System free -m total used free shared buffers cached Mem: 32109 31010 1099 0 3600 7287 -/+ buffers/cache: 20121 11987 Swap: 10239 1282 8957 Now according to my requirement Im calculating memory using below cmd free -m | awk 'NR==3{printf...

## Calculate the total 4 field based on the conditions

Please help me to write a script Match with ACNO & NAME if it matched calculate the total val1 val2 val3 and val4 and GT is total of ACNO wise.please check the output Table ----------------- 1005|ANDP|ACN|20|50|10|30 1005|ANDP|ACN|20|10|30|40 1001|AND|NAC|40|50|40|50...

## Calculate total value from a row

HI I have a file # cat marks.txt MARKS LIST 2013 Name english french chinese latin total_marks wer 34 45 67 23 wqa 12 39 10 56 wsy 23 90 23 78 Now i need to find the total marks of each student using...

## Calculate total of log by hour

Hi, Just wondering, is there anyway I can get the total of logs generated by hours ? Let say I have these logs, Sep 23 04:48:43 hsbcufs: NOTICE: realloccg /: file system full Sep 23 04:48:47 hsbcufs: NOTICE: alloc: /: file system full Sep 23 04:48:51 hsbcufs: NOTICE: realloccg /: file...

## Calculate total space, total used space and total free space in filesystem names matching keyword

Good afternoon! Im new at scripting and Im trying to write a script to calculate total space, total used space and total free space in filesystem names matching a keyword (in this one we will use keyword virginia). Please dont be mean or harsh, like I said Im new and trying my best. Scripting...

## Calculate total sum from a file

The file content is dynamic and using this format: name1 number1 name2 number2 name3 number3 name4 number4 .................... Need a smooth way to calculate the sum of all the numbers in that file (number1 + number2 + number3 + number4........ = total )

## awk script to calculate total

Hi First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears. I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines...

## Awk help needed to calculate total

Hi all, I have a flat file like 10 steven 25 mike 47 Charles 127 Nancy 34 steven 23 mike 67 Charles 7761 Nancy 8 steven 54 mike 88 Charles 1267 Nancy I need to calculate the total of steven and all the members , for this I am using like grep "`sed -n 1p patterns.txt`"...