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

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Grep all the columns based on a particular column

This is the data file that I have 21879, 0, 22, 58, 388 0, -1, 300, 1219172589765, 1708, 0, 200, 21891, 0, 0, 33, 309 0, -1, 300, 1219172591478, 1768, 0, 200, 22505, 0, 0, 33, 339 0, -1, 300, 1219172593251, 1738, 0, 200, 21888, 0, 1, 33, 308 0, -1, 300, 1219172594995, 633, 0, 200, 24878,...

2. Shell Programming and Scripting

sorting csv file based on column selected

Hi all, in my csv file it'll look like this, and of course it may have more columns US to UK;abc-hq-jcl;multimedia UK to CN;def-ny-jkl;standard DE to DM;abc-ab-klm;critical FD to YM;la-yr-tym;standard HY to MC;la-yr-ytm;multimedia GT to KJ;def-ny-jrt;critical I would like to group...

3. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which...

4. Shell Programming and Scripting

Awk to add selected row column data

Looks at the most efficient way to add up the column of data based off of the rows. Random data Name-Number-ID Sarah-2.0-15 Bob-6.3-15 Sally-1.0-10 James-1.0-10 Scotty-10.7-15 So I would select all those who have ID = 15 and then add up total number read - p "Enter ID number" Num ...

5. Shell Programming and Scripting

displaying columns based on column name

Hello, I have a huge file with many columns . I want to use the names of the columns to print columns to another file. for example file.txt COLA COLB COLC COLD 1 2 3 5 3 5 6 9 If I give name for multiple columns to the code:...

6. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column...

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

8. UNIX for Advanced & Expert Users

Conversion of rows to columns using awk based om column value

HI, My Input file data is dn:adcfgeneral id:13343 Name:xxxxxx Password:iutyerwuitywue wpuwt tuiytruityrutyrwtyrwp dn:cdferwjyyyy id:3875 Name:yyyy Password :hgfdsjkfhdsfkdlshf dshfkldshfdklsfh interset:uiuiufj My output should be ...

9. Shell Programming and Scripting

Combine multiple rows based on selected column keys

Hello I want to collapse a file with multiple rows into consolidated lines of entries based on selected columns as the 'key'. Example: 1 2 3 Abc def ghi 1 2 3 jkl mno p qrts 6 9 0 mno def Abc 7 8 4 Abc mno mno abc 7 8 9 mno mno abc 7 8 9 mno j k So if columns 1, 2 and 3 are...

10. UNIX for Beginners Questions & Answers

Is it possible to ascend a numbers based on selected columns?

I have to ascend the number of two selected columns by horizontal manner. For example, I have a data like this in csv file (tab delimited format) 08 1 19185 18010 16 4 7960 9339 01 6 516769 517428 09 9 51384 49270 I need to ascend the two columns numbers (horizontal manner) like as...

LEARN ABOUT DEBIAN

globus-gram-audit

GLOBUS-GRAM-AUDIT(8)						  GRAM5 Commands					      GLOBUS-GRAM-AUDIT(8)

NAME

       globus-gram-audit - Load GRAM4 and GRAM5 audit records into a database

SYNOPSIS

       globus-gram-audit [--conf CONFIG_FILE] [[--create] | [--update=OLD-VERSION]] [--check] [--delete] [--audit-directory AUDITDIR] [--quiet]

DESCRIPTION

       The globus-gram-audit program loads audit records to an SQL-based database. It reads $GLOBUS_LOCATION/etc/globus-job-manager.conf by
       default to determine the audit directory and then uploads all files in that directory that contain valid audit records to the database
       configured by the globus_gram_job_manager_auditing_setup_scripts package. If the upload completes successfully, the audit files will be
       removed.

       The full set of command-line options to globus-gram-audit consist of:

       --conf CONFIG_FILE
			       Use CONFIG_FILE instead of the default from the
			       configuration file for audit database
			       configuration.
       --check
			       Check whether the insertion of a record was
			       successful by querying the database after
			       inserting the records. This is used in tests.
       --delete 	       Delete audit records from the database right
			       after inserting them. This is used in tests to
			       avoid filling the databse with test records.
       --audit-directory DIR   Look for audit records in DIR, instead of looking
			       in the directory specified in the job manager
			       configuration. This is used in tests to control
			       which records are loaded to the database and then
			       deleted.
       --query SQL	       Perform the given SQL query on the audit
			       database. This uses the database information from
			       the configuration file to determine how to
			       contact the database.
       --quiet		       Reduce the amount of output for common
			       operations.

FILES

       The globus-gram-audit uses the following files (paths relative to $GLOBUS_LOCATION.

       etc/globus-gram-job-manager.conf
					  GRAM5 job manager configuration. It includes the
					  default path to the audit directory
       etc/globus-gram-audit.conf
					  Audit configuration. It includes the information
					  needed to contact the audit database.

University of Chicago						    08/30/2011						      GLOBUS-GRAM-AUDIT(8)