Sponsored Content
Full Discussion: sum(col) finding from a file
Top Forums Shell Programming and Scripting sum(col) finding from a file Post 302187890 by ksmbabu on Tuesday 22nd of April 2008 07:32:49 AM
Old 04-22-2008
Hi

I have an file it looks like

USSR|8650|262|Asia
Canada|3852|24|North America
China|3692|866|Asia
USA|3615|219|North America
Brazil|3286|116|South America
India|1269|637|Asia
Argentina|1072|26|South America
Sudan|968|19|Africa
Algeria|920|18|Africa

I have written a shell program which is not working. Pl help me where i am going wrong

FILE=/path/a.sh
area=0
total=0

for area in `grep a.sh | awk -F'|' '{print $2}'`
do
total=$(($total+$area))
done
echo $total

I tried with matrixmadhan and aigles, But it is not working.

Thanks
Babu
 

10 More Discussions You Might Find Interesting

1. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

2. Shell Programming and Scripting

Compare - 1st col of file

Hi, I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them. First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies

3. Shell Programming and Scripting

Finding the sum of two numbers

cat *.out |grep "<some text>" | awk '{print $6}' For ex,This will reutrn me 11111 22222 is it possible to add these two numbers in the above given command itself?I can write this to a file and find the sum. But I prefer to this calculation in the above given line itself. Any... (3 Replies)
Discussion started by: prasperl
3 Replies

4. Shell Programming and Scripting

Finding Sum of Occurrances

Hello friends, I have a database export and with this export i need to find some statistics which is required. I take the export of a table with only 3 columns like this: 2nd 3rd 12th 123 05.11.2010 09:27 0 124 05.11.2010 09:28 0 125 05.11.2010 09:34 1 126 05.11.2010 09:39 0... (5 Replies)
Discussion started by: EAGL€
5 Replies

5. Shell Programming and Scripting

how to add new col in a file

Hi, Experts, I have a requirement as following: my source file: a a a b b c c c c I need add one more colume as following: 1 a 2 a 3 a 1 b 2 b 1 c 2 c (4 Replies)
Discussion started by: ken002
4 Replies

6. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

7. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

8. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

9. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

10. Shell Programming and Scripting

Need help in finding sum for values in 2 different fields

Hi there, I have 2 files in following format cat file_1 Storage Group Name: aaaa HBA UID SP Name SPPort ------- ------- ------ 0 21 Storage Group Name: bbbb HBA UID... (2 Replies)
Discussion started by: jpkumar10
2 Replies
DATEFMT_FORMAT(3)							 1							 DATEFMT_FORMAT(3)

IntlDateFormatter::format - Format the date/time value as a string

	Object oriented style

SYNOPSIS
public string IntlDateFormatter::format (mixed $value) DESCRIPTION
Procedural style string datefmt_format (IntlDateFormatter $fmt, mixed $value) Formats the time value as a string. PARAMETERS
o $fmt - The date formatter resource. o $value - Value to format. This may be a DateTime object, an IntlCalendar object, a numeric type representing a (possibly fractional) num- ber of seconds since epoch or an array in the format output by localtime(3). If a DateTime or an IntlCalendar object is passed, its timezone is not considered. The object will be formatted using the formaters configured timezone. If one wants to use the timezone of the object to be formatted, IntlDateFormatter.setTimeZone(3) must be called before with the objects timezone. Alterna- tively, the static function datefmt_formatObject(3) may be used instead. RETURN VALUES
The formatted string or, if an error occurred, FALSE. CHANGELOG
+-----------------+---------------------------------------------------+ | Version | | | | | | | Description | | | | +-----------------+---------------------------------------------------+ |5.5.0/PECL 3.0.0 | | | | | | | Support for providing IntlCalendar objects to | | | the $value parameter was added. | | | | | 5.3.4 | | | | | | | Support for providing DateTime objects to the | | | $value parameter was added. | | | | +-----------------+---------------------------------------------------+ EXAMPLES
Example #1 datefmt_format(3) example <?php $fmt = datefmt_create( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'First Formatted output is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'Second Formatted output is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'First Formatted output with pattern is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo "Second Formatted output with pattern is " . datefmt_format($fmt, 0); ?> Example #2 OO example <?php $fmt = new IntlDateFormatter( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'First Formatted output is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'Second Formatted output is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'First Formatted output with pattern is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'Second Formatted output with pattern is ' . $fmt->format(0); ?> The above example will output: First Formatted output is Wednesday, December 31, 1969 4:00:00 PM PT Second Formatted output is Mittwoch, 31. Dezember 1969 16:00 Uhr GMT-08:00 First Formatted output with pattern is 12/31/1969 Second Formatted output with pattern is 12/31/1969 Example #3 With IntlCalendar object <?php $tz = reset(iterator_to_array(IntlTimeZone::createEnumeration('FR'))); $formatter = IntlDateFormatter::create( 'fr_FR', IntlDateFormatter::FULL, IntlDateFormatter::FULL, $tz, IntlDateFormatter::GREGORIAN ); $cal = IntlCalendar::createInstance($tz, '@calendar=islamic-civil'); $cal->set(IntlCalendar::FIELD_MONTH, 8); //9th month, Ramadan $cal->set(IntlCalendar::FIELD_DAY_OF_MONTH, 1); //1st day $cal->clear(IntlCalendar::FIELD_HOUR_OF_DAY); $cal->clear(IntlCalendar::FIELD_MINUTE); $cal->clear(IntlCalendar::FIELD_SECOND); $cal->clear(IntlCalendar::FIELD_MILLISECOND); echo "In this islamic year, Ramadan started/will start on: ", $formatter->format($cal), " "; //Its the formatters timezone that is used: $formatter->setTimeZone('Asia/Tokyo'); echo "After changing timezone: ", $formatter->format($cal), " "; The above example will output: In this islamic year, Ramadan started/will start on: mardi 9 juillet 2013 19:00:00 heure avancee d'Europe centrale After changing timezone: mercredi 10 juillet 2013 02:00:00 heure normale du Japon SEE ALSO
datefmt_create(3), datefmt_parse(3), datefmt_get_error_code(3), datefmt_get_error_message(3), datefmt_format_object(3). PHP Documentation Group DATEFMT_FORMAT(3)
All times are GMT -4. The time now is 12:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy