I have a file which need to be summed up using date column.
I/P:
Code:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20
2017/01/01 b 30
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
2017/02/01 a 10
2017/02/01 b 40
2017/02/01 c 60
2017/02/01 a 10
2017/02/01 b 5
2017/02/01 c 15
2017/03/01 a 5
2017/03/01 b 15
2017/03/01 c 20
2017/03/01 d 10
2017/03/01 a 20
2017/03/01 b 25
2017/03/01 c 30
2017/03/01 d 20
2017/03/01 a 5
2017/03/01 b 15
2017/03/01 c 20
O/P:
Code:
2017/01/01 a 90
2017/01/01 b 100
2017/01/01 c 120
2017/02/01 a 30
2017/02/01 b 65
2017/02/01 c 105
2017/03/01 a 30
2017/03/01 b 55
2017/03/01 c 50
2017/03/01 d 30
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 04-13-2017 at 03:59 PM..
Reason: Added CODE tags.
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
I have a file in the following layout:
201008005946873001846130058030701006131840000000000000000000
201008006784994001154259058033001009527844000000000000000000
201008007323067002418095058034801002418095000000000000000000
201008007697126001722141058029101002214158000000000000000000... (2 Replies)
Hi All,
I have a file with below content
01/22/2014,23:43:00,1742.8,
01/22/2014,23:43:00,1742.8,
01/22/2014,23:44:00,1749.06666666667,
01/25/2014,23:45:00,2046.45,
01/25/2014,23:43:00,1742.8,
01/25/2014,23:44:00,1749.06666666667,
01/25/2014,23:45:00,2046.45,
01/25/2014,23:43:00,1742.8,... (4 Replies)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 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)
this is part of a KT i am going thru.
i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size.
sample data attached.
Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 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)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
LEARN ABOUT MOJAVE
lpstat
lpstat(1) Apple Inc. lpstat(1)NAME
lpstat - print cups status information
SYNOPSIS
lpstat [ -E ] [ -H ] [ -U username ] [ -h hostname[:port] ] [ -l ] [ -W which-jobs ] [ -a [ destination(s) ] ] [ -c [ class(es) ] ] [ -d ]
[ -e ] [ -o [ destination(s) ] ] [ -p [ printer(s) ] ] [ -r ] [ -R ] [ -s ] [ -t ] [ -u [ user(s) ] ] [ -v [ printer(s) ] ]
DESCRIPTION
lpstat displays status information about the current classes, jobs, and printers. When run with no arguments, lpstat will list active jobs
queued by the current user.
OPTIONS
The lpstat command supports the following options:
-E Forces encryption when connecting to the server.
-H Shows the server hostname and port.
-R Shows the ranking of print jobs.
-U username
Specifies an alternate username.
-W which-jobs
Specifies which jobs to show, "completed" or "not-completed" (the default). This option must appear before the -o option and/or any
printer names, otherwise the default ("not-completed") value will be used in the request to the scheduler.
-a [printer(s)]
Shows the accepting state of printer queues. If no printers are specified then all printers are listed.
-c [class(es)]
Shows the printer classes and the printers that belong to them. If no classes are specified then all classes are listed.
-d Shows the current default destination.
-e Shows all available destinations on the local network.
-h server[:port]
Specifies an alternate server.
-l Shows a long listing of printers, classes, or jobs.
-o [destination(s)]
Shows the jobs queued on the specified destinations. If no destinations are specified all jobs are shown.
-p [printer(s)]
Shows the printers and whether they are enabled for printing. If no printers are specified then all printers are listed.
-r Shows whether the CUPS server is running.
-s Shows a status summary, including the default destination, a list of classes and their member printers, and a list of printers and
their associated devices. This is equivalent to using the -d, -c, and -v options.
-t Shows all status information. This is equivalent to using the -r, -d, -c, -v, -a, -p, and -o options.
-u [user(s)]
Shows a list of print jobs queued by the specified users. If no users are specified, lists the jobs queued by the current user.
-v [printer(s)]
Shows the printers and what device they are attached to. If no printers are specified then all printers are listed.
CONFORMING TO
Unlike the System V printing system, CUPS allows printer names to contain any printable character except SPACE, TAB, "/", and "#". Also,
printer and class names are not case-sensitive.
The -h, -e, -E, -U, and -W options are unique to CUPS.
The Solaris -f, -P, and -S options are silently ignored.
SEE ALSO cancel(1), lp(1), lpq(1), lpr(1), lprm(1), CUPS Online Help (http://localhost:631/help)
COPYRIGHT
Copyright (C) 2007-2017 by Apple Inc.
26 May 2017 CUPS lpstat(1)
04-13-2017
