Sponsored Content
Full Discussion: Sort question
Top Forums UNIX for Beginners Questions & Answers Sort question Post 302992921 by jimmyf on Friday 3rd of March 2017 01:14:22 PM
Old 03-03-2017
Sort question

Have a text file containing 4 columns, the 4th column is sorted numerically in descending order. The 2nd column is alpha text. Been able to get the 4th column to sort in descending order. The 2nd column sorts correctly but it's also in reverse. Would like to be able to keep the 4th column sort numerically descending while the 2nd column is sorted a-z, not z-a. This is what I have and can't seem to get it to work because everything is reversed.
Code:
sort -k2 -k4 -r file

this is what I'm trying to get:
Code:
xxxx apples xxxx 100
xxxx apples xxxx 90
xxxx oranges xxxx 80
xxxx oranges xxxx 70
xxxx pears xxxx 100
xxxx pears xxxx 90

this is what I'm getting because everything is reversed:
Code:
xxxx pears xxxx 100
xxxx pears xxxx 90
xxxx oranges xxxx 80
xxxx oranges xxxx 70
xxxx apples xxxx 100
xxxx apples xxxx 90

I'm sure this is simple but just can't get it to work.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sort Question

M 47 HIS:LOT 32 DUTY 2 MIKE, FINISHED MIKE ACTIVE STATUS 23TASK YES GOOD 100TASK NO GOOD ======================================== M 47 HIS:LOT 1 DUTY 1 MIKE, FINISHED MIKE ACTIVE STATUS 23TASK YES GOOD ... (7 Replies)
Discussion started by: bobo
7 Replies

2. UNIX for Dummies Questions & Answers

Sort/Grep Question

Hello all, I have a test file that has the format: ..... O 3.694950 -.895050 1.480000 O 5.485050 .895050 1.480000 Ti -4.590000 4.590000 2.960000 Ti -2.295000 ... (5 Replies)
Discussion started by: aarondesk
5 Replies

3. UNIX for Dummies Questions & Answers

SORT question

I'm looking for a sort command that will sort by zip code first then by last name. (zip code is the last field, last name is first field) data file looks like this. Hope Bob 1234 Main ST. Colorado Springs, CO 80920 I was thinking along the lines of: sort -k9n address.data //for the... (2 Replies)
Discussion started by: ssgatbliss
2 Replies

4. UNIX for Dummies Questions & Answers

UNIX Sort question

I was trying to check for the sort of some columns (say 1-10) of particular file. Now, by default, the Unix sort uses as a separator whitespace (e.g. if you have 'foo bar' then it separates it into 'foo' and 'bar' to use as keys) Now, I know which particular columns I want to use as the sort... (1 Reply)
Discussion started by: rev.meister
1 Replies

5. Shell Programming and Scripting

sort question

Hi all. Is there a way that I can use the sort command too sort the following field by earliest time (12:00AM) to latest time (11:59PM)? 07:12PM 07:53PM 07:54PM 08:07PM 10:15AM 10:21AM TIA!!!!!! (1 Reply)
Discussion started by: lyoncc
1 Replies

6. Shell Programming and Scripting

sort question

Hi all. HPUX - posix shell - script question Here's my data: f1 f2 f3 f4 f5 f6 |02/12/09|12:33PM|3|Oceanview |OVT #1| VISA/MC |02/12/09|12:14PM|3|Oceanview |OVT #1| VISA/MC |02/12/09|09:13AM|4|Oceanview |OVT #1| VISA/MC ... (8 Replies)
Discussion started by: lyoncc
8 Replies

7. Shell Programming and Scripting

sort | uniq question

Hello, I have a large data file: 1234 8888 bbb 2745 8888 bbb 9489 8888 bbb 1234 8888 aaa 4838 8888 aaa 3977 8888 aaa I need to remove duplicate lines (where the first column is the duplicate). I have been using: sort file.txt | uniq -w4 > newfile.txt However, it seems to keep the... (11 Replies)
Discussion started by: palex
11 Replies

8. Shell Programming and Scripting

Sort question.

Hi Guys, I have a file to be sorted and uniq with the following format. S00001002|01|20021231 S00001002|01|20011031 S00001006|01|20120430 S00001006|01|20111231 S00001006|01|20111031 S00001006|01|20110831 S00001006|01|20110731 S00001006|01|20101231 S00001006|01|20091231... (5 Replies)
Discussion started by: nua7
5 Replies

9. UNIX for Dummies Questions & Answers

Sort command question

I have a file like this: /vol/eng_app_0103z /vol/eng_app_0103z /vol/eng_app_0120z /vol/eng_app_0126z /vol/eng_app_0144z /vol/eng_app_0150z /vol/eng_app_0154z /vol/eng_app_01551z /vol/eng_app_01552z /vol/eng_app_0155z /vol/eng_app_0164z /vol/eng_app_0199zWhen I use the sort command... (3 Replies)
Discussion started by: newbie2010
3 Replies

10. Shell Programming and Scripting

Sort command question

I have a question about what the sort command is doing. Here is some sample data: 348201310013RVE 2 600201310013GFJ 70 3302013020101NS 40 600201309013GFJ 70 The sort command that is running is as follows: sort -k 1,3 -k 12,4 input.txt > output.txt ... (6 Replies)
Discussion started by: Drenhead
6 Replies
AGR(4)							   BSD Kernel Interfaces Manual 						    AGR(4)

NAME
agr -- link aggregation pseudo network interface driver SYNOPSIS
pseudo-device agr DESCRIPTION
The agr driver provides link aggregation functionality (a.k.a. L2 trunking or bonding). It supports the IEEE 802.3ad Link Aggregation Control Protocol (LACP) and the Marker Protocol. The agr driver supports the following link specific flags for ifconfig(8): link0 Use the round-robin distribution algorithm. Don't use it unless you're really sure, because it violates the frame ordering rule. -link0 Use the default distribution algorithm, which is based on the hash of DA/SA, TCI, and, if available, some upper layer protocol infor- mation like ip(4) DA/SA. link1 Disable LACP. Prevents any LACP or Marker messaging which leaves the ports in the default static configuration. Set this prior to adding ports. EXAMPLES
Create an agr interface, agr0, and attach re0 and re1 to it. In other words, aggregate re0 and re1 so that they can be used as a single interface, agr0. The physical interfaces which are attached to the agr interface must not have any IP addresses, neither IPv4 nor IPv6. ifconfig re0 inet xxx.xxx.xxx.xxx delete ifconfig re0 inet6 fe80::xxxx:xxxx:xxxx:xxxx delete ifconfig re1 inet xxx.xxx.xxx.xxx delete ifconfig re1 inet6 fe80::xxxx:xxxx:xxxx:xxxx delete ifconfig agr0 create ifconfig agr0 agrport re0 ifconfig agr0 agrport re1 Destroy an interface created in the above example. ifconfig agr0 -agrport re0 ifconfig agr0 -agrport re1 ifconfig agr0 destroy SEE ALSO
ifconfig(8) STANDARDS
IEEE 802.3ad Aggregation of Multiple Link Segments HISTORY
The agr driver first appeared in NetBSD 4.0. AUTHORS
The agr driver was written by YAMAMOTO Takashi. BUGS
There is no way to configure LACP administrative variables, including system and port priorities. The current implementation of the agr driver always performs active-mode LACP and uses 0x8000 as system and port priorities. The agr driver uses the MAC address of the first-added physical interface as the MAC address of the agr interface itself. Thus, removing the physical interface and using it for another purpose can result in non-unique MAC addresses. The current implementation of the agr driver doesn't prevent unsafe operations like some ioctls against underlying physical interfaces. Such operations can result in unexpected behaviors, and are strongly discouraged. There is no way to configure agr interfaces without attaching physical interfaces. Physical interfaces being added to the agr interface shouldn't have any addresses except for link level address. Otherwise, the attempt will fail with EBUSY. Note that it includes an automatically assigned IPv6 link-local address. BSD
February 23, 2010 BSD
All times are GMT -4. The time now is 03:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy