Sponsored Content
Top Forums UNIX for Dummies Questions & Answers summing according to the column Post 302171440 by robotronic on Thursday 28th of February 2008 01:19:21 PM
Old 02-28-2008
Code:
awk '{ x[$2]+=$1 } END { for (month in x) print x[month], month }' input_file | sort -k2

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Summing on column

Hi Friends How to do sum on a column? I have a file like: FRED 500.01 TX SMITH 50.10 NY HARRY 5.00 CA 555.11 Sum on second column. I am trying using nawk like nawk 'BEGIN {FS="|"}; {printf $1"+"}' Thanks a lot for your help S :) (2 Replies)
Discussion started by: sbasetty
2 Replies

2. Shell Programming and Scripting

A summing issue

Hi All, Here is the problem: The input file is like as per below. Each record has 30 chars in total. Have to add the first 17 and the next 13 and append the output. Total records can vary. 000000004728800000000000003908 000000003005100000000000002484 000000002602200000000000002151... (5 Replies)
Discussion started by: er_ashu
5 Replies

3. Shell Programming and Scripting

summing values of a column

I have a file which contains data as below: ----------------------------------------------------------------------------------------------- GSPWeb Statistics for the period of last 20 days... (3 Replies)
Discussion started by: mohsin.quazi
3 Replies

4. Shell Programming and Scripting

Summing column value - using PERL

I'm new to perl programming. I've a csv file as below. 20100221, abc_1, 200 20100221, abc_4, 350 20100221, opq_3, 200 20100221, abc_5, 220 20100221, xyz_1, 500 20100221, abc_2, 500 20100221, abc_3, 100 20100221, xyz_2, 700 20100221, opq_2, 350 20100221, xyz_3, 100 20100221, opq_1, 230... (8 Replies)
Discussion started by: ganapati
8 Replies

5. Shell Programming and Scripting

summing from two different files

I have two files hhhh 3674.00 a 75 1535 183 2134 291 2452 442 2738 704 3048 a 1007 3549 1282 4413 1494 5001 1631 5217 1954 5610 a 2540 5832 3248 6080 3629 6264 4851 6600 7004 6985 ... (4 Replies)
Discussion started by: Indra2011
4 Replies

6. Shell Programming and Scripting

Summing up rows data regarding 1st column

Dear all, I have one file like LABEL A B C D E F G H I J K L M N G02100 64651.3 25630.7 8225.21 51238 267324 268005 234001 52410.9 18598.2 10611 10754.7 122535 267170 36631.4 G02100 12030.3 8260.15 8569.91 ... (4 Replies)
Discussion started by: AAWT
4 Replies

7. Shell Programming and Scripting

Please Help!!!! Awk for summing columns based on selected column value

a,b,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,aa,bb,cc,dd,ee,ff,gg,hh,ii a thru ii are digits and strings.... The awk needed....if coloumn 9 == i (coloumn 9 is string ), output the sum of x's(coloumn 22 ) in all records and sum of y's (coloumn 23 ) in all records in a file (records.txt).... (6 Replies)
Discussion started by: BrownBob
6 Replies

8. Shell Programming and Scripting

Summing a number column

hi All, i have a file in which only one column is there., test.txt ====== -900.01 -900.02 -900.03 -900.04 -900.05 -900.06 -900.07 -900.08 -900.09 900.01 900.02 900.03 900.04 900.05 (4 Replies)
Discussion started by: mechvijays
4 Replies

9. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

10. Shell Programming and Scripting

Mismatch in summing a column in UNIX

Hello, I am facing issue in summing up a column in unix.I am displaying a column sum up to 4 decimal places and below is the code snippet sed '1d' abc.csv | cut -d',' -f7 | awk '{s+=$1}END{ printf("%.4f\n",s)}' -170552450514.8603 example of data values in the column(not... (3 Replies)
Discussion started by: karthik adiga
3 Replies
NL_LANGINFO(3)						   BSD Library Functions Manual 					    NL_LANGINFO(3)

NAME
nl_langinfo -- get locale information LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <langinfo.h> char * nl_langinfo(nl_item item); DESCRIPTION
The nl_langinfo() function returns a pointer to a string containing information set by the program's locale. The names and values of item are defined in <langinfo.h>. The entries under Category indicate in which setlocale(3) category each item is defined. Constant Category Meaning CODESET LC_CTYPE Codeset name D_T_FMT LC_TIME String for formatting date and time D_FMT LC_TIME Date format string T_FMT LC_TIME Time format string T_FMT_AMPM LC_TIME A.M. or P.M. time format string AM_STR LC_TIME Ante-meridiem affix PM_STR LC_TIME Post-meridiem affix DAY_1 LC_TIME Name of the first day of the week (e.g.: Sunday) DAY_2 LC_TIME Name of the second day of the week (e.g.: Monday) DAY_3 LC_TIME Name of the third day of the week (e.g.: Tuesday) DAY_4 LC_TIME Name of the fourth day of the week (e.g.: Wednesday) DAY_5 LC_TIME Name of the fifth day of the week (e.g.: Thursday) DAY_6 LC_TIME Name of the sixth day of the week (e.g.: Friday) DAY_7 LC_TIME Name of the seventh day of the week (e.g.: Saturday) ABDAY_1 LC_TIME Abbreviated name of the first day of the week ABDAY_2 LC_TIME Abbreviated name of the second day of the week ABDAY_3 LC_TIME Abbreviated name of the third day of the week ABDAY_4 LC_TIME Abbreviated name of the fourth day of the week ABDAY_5 LC_TIME Abbreviated name of the fifth day of the week ABDAY_6 LC_TIME Abbreviated name of the sixth day of the week ABDAY_7 LC_TIME Abbreviated name of the seventh day of the week MON_1 LC_TIME Name of the first month of the year MON_2 LC_TIME Name of the second month MON_3 LC_TIME Name of the third month MON_4 LC_TIME Name of the fourth month MON_5 LC_TIME Name of the fifth month MON_6 LC_TIME Name of the sixth month MON_7 LC_TIME Name of the seventh month MON_8 LC_TIME Name of the eighth month MON_9 LC_TIME Name of the ninth month MON_10 LC_TIME Name of the tenth month MON_11 LC_TIME Name of the eleventh month MON_12 LC_TIME Name of the twelfth month ABMON_1 LC_TIME Abbreviated name of the first month ABMON_2 LC_TIME Abbreviated name of the second month ABMON_3 LC_TIME Abbreviated name of the third month ABMON_4 LC_TIME Abbreviated name of the fourth month ABMON_5 LC_TIME Abbreviated name of the fifth month ABMON_6 LC_TIME Abbreviated name of the sixth month ABMON_7 LC_TIME Abbreviated name of the seventh month ABMON_8 LC_TIME Abbreviated name of the eighth month ABMON_9 LC_TIME Abbreviated name of the ninth month ABMON_10 LC_TIME Abbreviated name of the tenth month ABMON_11 LC_TIME Abbreviated name of the eleventh month ABMON_12 LC_TIME Abbreviated name of the twelfth month ERA LC_TIME Era description segments ERA_D_FMT LC_TIME Era date format string ERA_D_T_FMT LC_TIME Era date and time format string ERA_T_FMT LC_TIME Era time format string ALT_DIGITS LC_TIME Alternative symbols for digits RADIXCHAR LC_NUMERIC Radix character THOUSEP LC_NUMERIC Separator for thousands YESEXPR LC_MESSAGES Affirmative response expression NOEXPR LC_MESSAGES Negative response expression RETURN VALUES
nl_langinfo() returns a pointer to an empty string if item is invalid. EXAMPLES
The following example uses nl_langinfo() to obtain the date and time format for the current locale: #include <time.h> #include <langinfo.h> #include <locale.h> int main(void) { char datestring[100]; struct tm *tm; time_t t; char *ptr; t = time(NULL); tm = localtime(&t); (void)setlocale(LC_ALL, ""); ptr = nl_langinfo(D_T_FMT); strftime(datestring, sizeof(datestring), ptr, tm); printf("%s ", datestring); return (0); } SEE ALSO
setlocale(3), tm(3), nls(7) STANDARDS
The nl_langinfo() function conforms to IEEE Std 1003.1-2001 (``POSIX.1''). HISTORY
The nl_langinfo() function appeared in NetBSD 1.0. BSD
April 14, 2011 BSD
All times are GMT -4. The time now is 08:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy