I want to sum value in column 2 based on column 6 and column 4
i expect the result
thanks for the help
I think I can produce the output you want, but I can't reconcile the output you have shown with your description of what you want done. The sum of the A's, B's, and C's in column 2 doesn't seem to play any role in the output. The two lines that you seem to have combined (the 1st line and the 3rd line in your input) have matching values in columns 1 and 6; not 6 and 4.
Would a more accurate statement of your requirements be?
For every line in the input file where the 1st field and the 6th field are the same, print the 1st field, the 6th field, and the sum of the values in the 3rd field.
Does the order of the output lines matter? If it does, please describe the required order
Last edited by Don Cragun; 07-19-2013 at 01:22 PM..
Reason: Sum of 3rd field; not 4th.
Hi,
I am new to this forum and new to awk.
I have a file that contains 2 columns.
Heres an example of what it looks like:
10 +
20 +
40 +
50 -
70 -
So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1... (1 Reply)
i have a file - it will be in sorted order on column 1
abc 0 1
abc 2 3
abc 3 5
def 1 7
def 0 1
--------
i'd like (awk maybe?) to get the results (any ideas)???
abc 5 9
def 1 8 (2 Replies)
Hi,
I have below as i/p file:
5ABC 36488989 K 000010000ASB BYTRES
5PQR 45757754 K 000200005KPC HGTRET
5ABC 36488989 K 000045000ASB HGTRET
5GTH 36488989 K 000200200ASB BYTRES
5FTU ... (2 Replies)
I have a following inputfile
MT,AP,CDM,TTML,MUM,GS,SUCC,3
MT,AP,CDM,TTSL,AP,GS,FAIL,9
MT,AP,CDM,RCom,MAH,GS,SUCC,3
MT,AP,CDM,RTL,HP,GS,SUCC,1
MT,AP,CDM,Uni,UPE,GS,SUCC,2
MT,AP,CDM,Uni,MUM,GS,SUCC,2
TTSL,AP,GS,MT,MAH,CDM,SUCC,20
TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
i have file input
aaa ccc,45567,rterw,1
bbb dcs,564543,hjghgh,1
aaa ccc,454,rterw,6
i want to sum based on column 1
expected output
aaa ccc,7
bbb dcs,1 (4 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Hi All,
I have a file as below and want to sum based on the id in the first column
Input
10264;ATE; 12
10265;SES;11
10266AUT;50
10264;ATE;10
10265;SES;13
10266AUT;89
10264;ATE;1
10265;SES;15
10266AUT;78
Output
10264;ATE; 23
10265;SES;39
10266AUT;139 (6 Replies)
Discussion started by: arunkumar_mca
6 Replies
LEARN ABOUT PHP
intlcalendar.getminimaldaysinfirstweek
INTLCALENDAR.GETMINIMALDAYSINFIRSTWEEK(3) 1 INTLCALENDAR.GETMINIMALDAYSINFIRSTWEEK(3)IntlCalendar::getMinimalDaysInFirstWeek - Get minimal number of days the first week in a year or month can have
Object oriented style
SYNOPSIS
public int IntlCalendar::getMinimalDaysInFirstWeek (void )
DESCRIPTION
Procedural style
int intlcal_get_minimal_days_in_first_week (IntlCalendar $cal)
Returns the smallest number of days the first week of a year or month must have in the new year or month. For instance, in the Gregorian
calendar, if this value is 1, then the first week of the year will necessarily include January 1st, while if this value is 7, then the week
with January 1st will be the first week of the year only if the day of the week for January 1st matches the day of the week returned by
IntlCalendar.getFirstDayOfWeek(3); otherwise it will be the previous years last week.
PARAMETERS
o $cal
- The IntlCalendar resource.
RETURN VALUES
An int representing a number of days or FALSE on failure.
EXAMPLES
Example #1
IntlCalendar.getMinimalDaysInFirstWeek(3)
<?php
ini_set('date.timezone', 'UTC');
ini_set('intl.default_locale', 'en_US');
$cal = new IntlGregorianCalendar(2013, 0 /* January */, 2);
var_dump(IntlDateFormatter::formatObject($cal, 'cccc')); // Wednesday
var_dump($cal->getMinimalDaysInFirstWeek(), // 1
$cal->getFirstDayofWeek()); // 1 (Sunday)
// Week 1 of 2013
var_dump(IntlDateFormatter::formatObject($cal, "'Week 'w' of 'Y"));
$cal->setMinimalDaysInFirstWeek(4);
// Still Week 1 of 2013 (1st week has 5 days in the new year)
var_dump(IntlDateFormatter::formatObject($cal, "'Week 'w' of 'Y"));
$cal->setMinimalDaysInFirstWeek(6);
// Week 53 of 2012
var_dump(IntlDateFormatter::formatObject($cal, "'Week 'w' of 'Y"));
The above example will output:
string(9) "Wednesday"
int(1)int(1)string(14) "Week 1 of 2013"
string(14) "Week 1 of 2013"
string(15) "Week 53 of 2012"
PHP Documentation Group INTLCALENDAR.GETMINIMALDAYSINFIRSTWEEK(3)