Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calculate the total
Top Forums Shell Programming and Scripting Calculate the total Post 302888316 by ust3 on Thursday 13th of February 2014 08:30:35 PM
Old 02-13-2014
Quote:
Originally Posted by Chubler_XL
In your above script you could replace:

Code:
printf "\n"
echo "======="


done < file.txt

with:

Code:
LineTotal=$(($(IFS=+; echo "${TableCount[*]}")))
printf "%*s%*s\n" $(( $((11 + ${#LineTotal}))/2 )) "$LineTotal" $(( $((10 - ${#LineTotal}))/2 )) "|"

done < file.txt

thanks reply ,

I replaced the code as your advice , the result is as below

Code:
No. of "aaa" in Feb 2014 = 
         |Jan 2014 |Feb 2014 |  Total  |
=========|=========|=========|=========|
         |     2   |     4   |     6   |
No. of "bbb" in Feb 2014 = 
         |Jan 2014 |Feb 2014 |Jan 2014 |Feb 2014 |  Total  |
=========|=========|=========|=========|=========|=========|
         |     2   |     4   |     2   |     5   |    13   |

However ,the above data is duplicated , the output should be

Code:
No. of "aaa" in Feb 2014 = 
|Jan 2014 |Feb 2014 |  Total  |
|=========|=========|=========|
|     2   |     4   |     6   |
No. of "bbb" in Feb 2014 =  
|Jan 2014 |Feb 2014 |  Total  |
|=========|=========|=========|
|     2   |     5   |    13   |


Could advise how to modify it ? thanks
Last edited by Don Cragun; 02-13-2014 at 09:37 PM.. Reason: Fix and add CODE tags.
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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`"... (7 Replies)
Discussion started by: senthilkumar_ak
7 Replies

2. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: appsguy616
2 Replies

3. Shell Programming and 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 ) (11 Replies)
Discussion started by: TehOne
11 Replies

4. Shell Programming and Scripting

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... (4 Replies)
Discussion started by: bigben1220
4 Replies

5. Shell Programming and Scripting

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... (14 Replies)
Discussion started by: dehetoxic
14 Replies

6. Shell Programming and Scripting

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... (11 Replies)
Discussion started by: Priya Amaresh
11 Replies

7. Shell Programming and Scripting

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... (22 Replies)
Discussion started by: kalia4u
22 Replies

8. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: sam@sam
2 Replies

LEARN ABOUT CENTOS

datetime::locale::xh

DateTime::Locale::xh(3) 				User Contributed Perl Documentation				   DateTime::Locale::xh(3)

NAME

       DateTime::Locale::xh

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'xh' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Xhosa.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 Mvulo
	 Lwesibini
	 Lwesithathu
	 Lwesine
	 Lwesihlanu
	 Mgqibelo
	 Cawe

       Abbreviated (format)

	 Mvu
	 Bin
	 Tha
	 Sin
	 Hla
	 Mgq
	 Caw

       Narrow (format)

	 Mvu
	 Bin
	 Tha
	 Sin
	 Hla
	 Mgq
	 Caw

       Wide (stand-alone)

	 Mvulo
	 Lwesibini
	 Lwesithathu
	 Lwesine
	 Lwesihlanu
	 Mgqibelo
	 Cawe

       Abbreviated (stand-alone)

	 Mvu
	 Bin
	 Tha
	 Sin
	 Hla
	 Mgq
	 Caw

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 Janyuwari
	 Februwari
	 Matshi
	 Epreli
	 Meyi
	 Juni
	 Julayi
	 Agasti
	 Septemba
	 Okthoba
	 Novemba
	 Disemba

       Abbreviated (format)

	 Jan
	 Feb
	 Mat
	 Epr
	 Mey
	 Jun
	 Jul
	 Aga
	 Sep
	 Okt
	 Nov
	 Dis

       Narrow (format)

	 Jan
	 Feb
	 Mat
	 Epr
	 Mey
	 Jun
	 Jul
	 Aga
	 Sep
	 Okt
	 Nov
	 Dis

       Wide (stand-alone)

	 Janyuwari
	 Februwari
	 Matshi
	 Epreli
	 Meyi
	 Juni
	 Julayi
	 Agasti
	 Septemba
	 Okthoba
	 Novemba
	 Disemba

       Abbreviated (stand-alone)

	 Jan
	 Feb
	 Mat
	 Epr
	 Mey
	 Jun
	 Jul
	 Aga
	 Sep
	 Okt
	 Nov
	 Dis

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 1 unyangantathu
	 2 unyangantathu
	 3 unyangantathu
	 4 unyangantathu

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 1 unyangantathu
	 2 unyangantathu
	 3 unyangantathu
	 4 unyangantathu

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BC
	 umnyaka wokuzalwa kukaYesu

       Abbreviated

	 BC
	 AD

       Narrow

	 BC
	 AD

   Date Formats
       Full

	  2008-02-05T18:30:30 = Lwesibini, 2008 Februwari 05
	  1995-12-22T09:05:02 = Lwesihlanu, 1995 Disemba 22
	 -0010-09-15T04:44:23 = Mgqibelo, -10 Septemba 15

       Long

	  2008-02-05T18:30:30 = 2008 Februwari 5
	  1995-12-22T09:05:02 = 1995 Disemba 22
	 -0010-09-15T04:44:23 = -10 Septemba 15

       Medium

	  2008-02-05T18:30:30 = 2008 Feb 5
	  1995-12-22T09:05:02 = 1995 Dis 22
	 -0010-09-15T04:44:23 = -10 Sep 15

       Short

	  2008-02-05T18:30:30 = 2008-02-05
	  1995-12-22T09:05:02 = 1995-12-22
	 -0010-09-15T04:44:23 = -010-09-15

       Default

	  2008-02-05T18:30:30 = 2008 Feb 5
	  1995-12-22T09:05:02 = 1995 Dis 22
	 -0010-09-15T04:44:23 = -10 Sep 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Lwesibini, 2008 Februwari 05 18:30:30 UTC
	  1995-12-22T09:05:02 = Lwesihlanu, 1995 Disemba 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = Mgqibelo, -10 Septemba 15 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 2008 Februwari 5 18:30:30 UTC
	  1995-12-22T09:05:02 = 1995 Disemba 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = -10 Septemba 15 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 2008 Feb 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Dis 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Sep 15 04:44:23

       Short

	  2008-02-05T18:30:30 = 2008-02-05 18:30
	  1995-12-22T09:05:02 = 1995-12-22 09:05
	 -0010-09-15T04:44:23 = -010-09-15 04:44

       Default

	  2008-02-05T18:30:30 = 2008 Feb 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Dis 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Sep 15 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Bin
	  1995-12-22T09:05:02 = 22 Hla
	 -0010-09-15T04:44:23 = 15 Mgq

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Bin, 2-5
	  1995-12-22T09:05:02 = Hla, 12-22
	 -0010-09-15T04:44:23 = Mgq, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = Feb
	  1995-12-22T09:05:02 = Dis
	 -0010-09-15T04:44:23 = Sep

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Feb 5
	  1995-12-22T09:05:02 = Dis 22
	 -0010-09-15T04:44:23 = Sep 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Bin Feb 5
	  1995-12-22T09:05:02 = Hla Dis 22
	 -0010-09-15T04:44:23 = Mgq Sep 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = Februwari 5
	  1995-12-22T09:05:02 = Disemba 22
	 -0010-09-15T04:44:23 = Septemba 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Bin Februwari 5
	  1995-12-22T09:05:02 = Hla Disemba 22
	 -0010-09-15T04:44:23 = Mgq Septemba 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Bin, 2008-2-5
	  1995-12-22T09:05:02 = Hla, 1995-12-22
	 -0010-09-15T04:44:23 = Mgq, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Feb
	  1995-12-22T09:05:02 = 1995 Dis
	 -0010-09-15T04:44:23 = -10 Sep

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Bin, 2008 Feb 5
	  1995-12-22T09:05:02 = Hla, 1995 Dis 22
	 -0010-09-15T04:44:23 = Mgq, -10 Sep 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Februwari
	  1995-12-22T09:05:02 = 1995 Disemba
	 -0010-09-15T04:44:23 = -10 Septemba

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       Mvulo

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.16.3							    2014-06-10						   DateTime::Locale::xh(3)
All times are GMT -4. The time now is 11:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy