1

Sum up the column values group by using some field

view story
linux-howto

http://www.unix.com – Code: 12-11-2012,PNL,158406 12-11-2012,RISK,4564 12-11-2012,VAR_1D,310101 12-11-2012,VAR_10D,310101 12-11-2012,CB,866 12-11-2012,STR_VAR_1D,298494 12-11-2012,STR_VAR_10D,309623 09-11-2012,PNL,1024106 09-11-2012,RISK,4565 09-11-2012,VAR_1D,317211 09-11-2012,VAR_10D,317211 09-11-2012,CB,985 09-11-2012,JOB,640 09-11-2012,STR_VAR_1D,305364 09-11-2012,STR_VAR_10D,317211 I have a flat file like above, So all I need to sum up column 3 values if column 2 matches word VAR for coulmn 1 date So foe 12 Nov I summed up VAR_1D, VAR_10D, STR_VAR_1D, STR_VAR_10D same goes for 09 Nov So my final file lo (HowTos)

jiqi2's picture
Submitted by jiqi2 on 11/13/2012

Stories similar to Sum up the column values group by using some field

Hi,

I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values.

How can I achieve this Unix

Here is the sample data.

Hi,

I have a data file with :

01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083

I need to find the first occurring date and the last occurring date for a particular value in column 4

when i run this command:

Code: tail -200 /var/log/httpd/access_log | awk -F'[][]' '{sub(/:[^:]*$/,"",$2);print $2}' i get:

Code: 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 now i need to alter the awk command

Basics:I'm running SQL Server 2008 R2 Standard.

I need to create a query that has data from multiple columns (Columns 1-6 with coresponding Date started and Date Completed data) displayed vertically, but also has the column name the preeceeding column to identify it...along with other data (Record number, status).

Record Number, Status, Column Name, Date Started, DateCompleted 1, Open, Column 1,

Hi

my data is in csv-format ...

Code: ... 13/08/2012,16:30,303.30,5.10,3,2,2,1,9360.0,322 13/08/2012,16:40,305.50,5.00,3,2,2,1,12360.0,322 13/08/2012,16:50,319.90,3.80,3,2,1,0,2280.0 13/08/2012,17:00,326.10,3.50,3,2,1,1,4380.0,321 13/08/2012,17:10,333.00,3.80,3,3,1,0,2280.0 13/08/2012,17:20,330.20,4.50,3,3,2,0,2700.0 13/08/2012,17:30,332.00,4.20,3,3,2,1,5220.0,332 13/08/2012,17:40,334.90,3.

I have an input list of:

Quote:

2/10/2012 9:19 PM EST 2/10/2012 8:48 PM EST 2/16/2012 2:49 PM EST 2/16/2012 6:06 PM EST 2/14/2012 8:30 PM EST 2/13/2012 2:44 PM EST 2/13/2012 6:06 PM EST 2/14/2012 4:36 PM EST 2/11/2012 7:01 PM EST 2/16/2012 11:48 AM EST 2/15/2012 6:16 PM EST 2/13/2012 12:59 PM EST

I am just trying to turn this list into its seconds

The error is 2147746321.

I can see in the mailserver log that it tries, but the connection gets closed.

Script read highest value 49 weeks 5 days ago

Hi All,

Can someone help steer me to the simplest approach to write a script that reads the second column of a csv file and returns the highest value.

example file:

DATE,QUANTITY Mon Apr 30 01:56:00 2012,42 Mon Apr 30 02:24:00 2012,72 Mon Apr 30 02:56:00 2012,102 Mon Apr 30 02:59:00 2012,132 Mon Apr 30 03:31:00 2012,222 Mon Apr 30 03:38:00 2012,192

TIA

Hi Friends, Require a quick help to write the difference between 2 timestamps based on a unique column value: Input file:

Code: 08/23/2012 12:36:09,JOB_5340,08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350,08/23/2012 12:36:26,JOB_5350 08/23/2012 13:08:51,JOB_5360,08/23/2012 13:08:58,JOB_5360 Output Required:

Code: 08/23/2012 12:36:14,08/23/2012 12:36:09,00:00:05,JOB_5340 08/23/