sum multiple columns based on column value Post: 302401980

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

2. Shell Programming and Scripting

Sum a column value based on multiple keys

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 ...

3. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

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...

4. Shell Programming and Scripting

Sum of multiple columns based on few conditions

Input file: 0014,A,2020,K,011115000000,xyxxxxxxxxxxxxxx ,B,00001,0003200,0000111 0014,A,2020,K,011115000000,xyxxxxxxxxxxxxxx ,B,00001,0003300,0000100 0014,A,2020,K,011116000000,xyxxxxxxxxxxxxxx ,B,00001,0003400,0000100 0014,A,2020,K,011116000000,xyxxxxxxxxxxxxxx ,B,00007,0003100,0000200...

5. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

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...

6. Shell Programming and Scripting

Paste columns based on common column: multiple files

Hi all, I've multiple files. In this case 5. Space separated columns. Each file has 12 columns. Each file has 300-400K lines. I want to get the output such that if a value in column 2 is present in all the files then get all the columns of that value and print it side by side. Desired output...

7. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

8. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

10. Shell Programming and Scripting

Sum of a column as new column based on header in a script

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...

LEARN ABOUT DEBIAN

rt-clean-sessions-4

rt-clean-sessions(8)					     Request Tracker Reference					      rt-clean-sessions(8)

NAME

       rt-clean-sessions - clean old and duplicate RT sessions

SYNOPSIS

	    rt-clean-sessions [--debug] [--older <NUM>[H|D|M|Y]]

	    rt-clean-sessions
	    rt-clean-sessions --debug
	    rt-clean-sessions --older 10D
	    rt-clean-sessions --debug --older 1M
	    rt-clean-sessions --older 10D --skip-user

DESCRIPTION

       Script cleans RT sessions from DB or dir with sessions data.  Leaves in DB only one session per RT user and sessions that aren't older than
       specified(see options).

       Script is safe because data in the sessions is temporary and can be deleted.

OPTIONS

       older
	   Date interval in the "<NUM>[<unit>]" format. Default unit is D(ays), H(our), M(onth) and Y(ear) are also supported.

	   For example: "rt-clean-sessions --older 1M" would delete all sessions that are older than 1 month.

       skip-user
	   By default only one session per user left in the DB, so users that have sessions on multiple computers or in different browsers will be
	   logged out.	Use this option to avoid this.

       debug
	   Turn on debug output.

NOTES

       Functionality similar to this is implemented in html/Elements/SetupSessionCookie ; however, that does not guarantee that a session will be
       removed from disk and database soon after the timeout expires.  This script, if run from a cron job, will ensure that the timed out
       sessions are actually removed from disk; the Mason component just ensures that the old sessions are not reusable before the cron job gets
       to them.

perl v5.14.2							    2013-05-22						      rt-clean-sessions(8)