HHow to print the group with a highest value within a set
How to print the names with a highest value within a set and filter if it is the only unique group within the same set
input
Code:
sets names value groups
j007 shot1 0.6 a
j007 shot2 0.5 b
j007 shot3 0.4 bb
j007 shot4 0.3 bc
j007 shot5 0.2 cd
j008 shot1 0.4 a
j008 shot2 0.3 ab
j009 shot1 0.14 a
j009 shot2 0.13 b
j009 shot3 0.12 bc
j010 shot1 22 a
j010 shot2 19 b
j010 shot3 5 bcd
j011 shot1 5 a
j011 shot2 2 b
j011 shot3 3 c
output
Code:
j007 shot1 0.6 a
j009 shot1 0.14 a
j010 shot1 22 a
Tried
Code:
sort -k 3,3 input | awk '$3*$3>A[$1]*A[$1]{A[$1]=$0} END{for(i in A) print i,A[i]}' | sort -k 1,1
Last edited by quincyjones; 06-12-2017 at 05:00 PM..
I've this file and need to sort the data in each group
File would look like this ...
cat file1.txt
Reason : ABC
12345-0023
32123-5400
32442-5333
Reason : DEF
42523-3453
23345-3311
Reason : HIJ
454553-0001
I would like to sort each group on the last 4 fileds and print them... (11 Replies)
Hi everyone,
This is my first post, but I have already received a lot of help from the forums in the past. Thanks!
I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a... (1 Reply)
Hi everyone,
This is my first post, but I have already received a lot of help from the forums in the past. Thanks!
I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a... (3 Replies)
Just want to say this is great resources for all thing Unix!!
cat tmp.txt
A 3
C 19
A 2
B 5
A 1
A 0
C 13
B 9
C 1
Desired output:
A 3
B 9
C 19
The following work but I am wondering if there is a better way to do it: (4 Replies)
There are some duplicate field on description column .I want to print duplicate row along with highest version of number and corresponding description column.
file1.txt
number Description
=== ============
34567 nl21a00is-centerdb001:ncdbareq:Error in loading init
34577 ... (7 Replies)
Hi, I have a little issue right now.
I have a file with 4 columns
test0000002,10030010330,c_,218
test0000002,10030010330,d_,202
test0000002,10030010330,b_,193
test0000002,10030010020,c_,178
test0000002,10030010020,b_,170
test0000002,10030010330,a_,166
test0000002,10030010020,a_,151... (2 Replies)
Hi, I have a little issue right now.
I have a file with 4 columns
test0000002,10030010330,c_,218
test0000002,10030010330,d_,202
test0000002,10030010330,b_,193
test0000002,10030010020,c_,178
test0000002,10030010020,b_,170
test0000002,10030010330,a_,166
test0000002,10030010020,a_,151... (3 Replies)
grepping on a value but then want to print only those lines that have the highest value in the 4th column
log text text R59FJ
log text text R63FT
log text text R60JX
log1 text text R63EA
log1 text text R60JX desired output
log text text R63FT
log1 text text R63EAtried this but not getting... (2 Replies)
Discussion started by: jimmyf
2 Replies
LEARN ABOUT X11R4
lpusers
lpusers(1M) System Administration Commands lpusers(1M)NAME
lpusers - set printing queue priorities
SYNOPSIS
lpusers -d priority-level
lpusers -q priority-level -u login-ID-list
lpusers -u login-ID-list
lpusers -q priority-level
lpusers -l
DESCRIPTION
The lpusers command sets limits to the queue priority level that can be assigned to jobs submitted by users of the LP print service.
The first form of the command (with -d) sets the system-wide priority default to priority-level, where priority-level is a value of 0 to
39, with 0 being the highest priority. If a user does not specify a priority level with a print request (see lp(1)), the default priority
level is used. Initially, the default priority level is 20.
The second form of the command (with -q and -u) sets the default highest priority-level (0-39) that the users in login-ID-list can request
when submitting a print request. The login-ID-list argument may include any or all of the following constructs:
login-ID A user on any system
system_name!login-ID A user on the system system_name
system_name!all All users on system system_name
all!login-ID A user on all systems
all All users on all systems
Users that have been given a limit cannot submit a print request with a higher priority level than the one assigned, nor can they change a
request that has already been submitted to have a higher priority. Any print requests submitted with priority levels higher than allowed
will be given the highest priority allowed.
The third form of the command (with -u) removes any explicit priority level for the specified users.
The fourth form of the command (with -q) sets the default highest priority level for all users not explicitly covered by the use of the
second form of this command.
The last form of the command (with -l) lists the default priority level and the priority limits assigned to users.
OPTIONS
The following options are supported:
-d priority-level
Set the system-wide priority default to priority-level.
-l
List the default priority level and the priority limits assigned to users.
-q priority-level
Set the default highest priority level for all users not explicitly covered.
-q priority-level -u login-ID-list
Set the default highest priority-level that the users in login-ID-list can request when submitting a print request.
-u login-ID-list
Remove any explicit priority level for the specified users.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
non-zero An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpsu |
+-----------------------------+-----------------------------+
SEE ALSO lp(1), attributes(5)SunOS 5.10 19 Aug 1996 lpusers(1M)