Sponsored Content
Top Forums Shell Programming and Scripting Question about sort specific column and print other column at the same time ! Post 302359658 by patrick87 on Wednesday 7th of October 2009 06:22:53 AM
Old 10-07-2009
Question about sort specific column and print other column at the same time !

Hi,

This is my input file:
Code:
ali 5 usa abc
abu 4 uk bca
alan 6 brazil bac
pinky 10 utah sdc

My desired output:
Code:
pinky 10 utah sdc
alan 6 brazil bac
ali 5 usa abc
abu 4 uk bca

Based on the column two, I want to do the descending order and print out other related column at the same time.
Does anybody know how to do it?
I'm not sure whether awk can do this or not?
Thanks for all of your suggestionSmilie
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sort by column or specific order

Hi, I need to sort it by column or need it in a specific order... input is ===== uid=shashi country= india region =0 ph=0 uid= jon region= asia ph= 12345 country=0 uid = man country= india ph=2222 region=0 uid= neera region= asia ph= 125 country=0 output should be uid=shashi ... (1 Reply)
Discussion started by: hegdeshashi
1 Replies

2. Shell Programming and Scripting

Print rows, having pattern in specific column...

Hello all, :) I have a pattern file some what like this, cd003 cd005 cd007 cd008 and input file like this, abc cd001 cd002 zca bca cd002 cd003 cza cba cd003 cd004 zca bac cd004 cd005 zac cba cd005 cd006 acz acb cd006 cd007 caz cab cd007 ... (25 Replies)
Discussion started by: admax
25 Replies

3. Shell Programming and Scripting

Print out specific pattern column data

Input file: adc_0123 haa_1000 bcc_520 adc_0150 bcc_290 adc_0112 haa_8000 adc_0139 haa_7000 Output file: adc_0123 adc_0123 haa_1000 bcc_520 adc_0150 adc_0150 bcc_290 (3 Replies)
Discussion started by: patrick87
3 Replies

4. UNIX for Dummies Questions & Answers

print a specific column

Hi I want to print column2 if column1 is b with: awk '$1==b {print $2}' infile > outfile infile a 1 b 2 c 3 b 4 e 5 b 6 the outfile is empty. it should look like this: 2 4 6 (2 Replies)
Discussion started by: jdhahbi
2 Replies

5. Shell Programming and Scripting

print first few lines, then apply regex on a specific column to print results.

abc.dat tty cpu tin tout us sy wt id 0 0 7 3 19 71 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 133.2 0.0 682.9 0.0 1.0 0.0 7.2 0 79 c1t0d0 0.2 180.4 0.1 5471.2 3.0 2.8 16.4 15.6 15 52 aaaaaa1-xx I want to skip first 5 line... (4 Replies)
Discussion started by: kchinnam
4 Replies

6. Shell Programming and Scripting

Help with sort alphabet on specific column

Input file: POL B7U6K8 Avian_reticuloendotheliosis_virus POLB B7Z1W5 Homo_sapiens POLB H9G5Y0 Anolis_carolinensis POLD1 Q642R8 Xenopus_laevis POLD2 H0YZC7 Taeniopygia_guttata POLD3 F1P540 Gallus_gallus POLDIP3 Q5F4B6 Gallus_gallus POLE2 E1C2T8 Gallus_gallus... (3 Replies)
Discussion started by: perl_beginner
3 Replies

7. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

Help with print out line that have different record in specific column

Input file 1: - 7367 8198 - 8225 9383 + 9570 10353 Input file 2: - 2917 3667 - 3851 4250 + 4517 6302 + 6302 6740 + 6768 7524 + 7648 8170 + 8272 8896 + 8908 9915 - 10010 ... (18 Replies)
Discussion started by: perl_beginner
18 Replies

9. Shell Programming and Scripting

How to print multiple specific column after a specific word?

Hello.... Pls help me (and sorry my english) :) So I have a file (test.txt) with 1 long line.... for example: isgc jsfh udgf osff 8462 error iwzr 653 idchisfb isfbisfb sihfjfeb isfhsi gcz eifh How to print after the "error" word the 2nd 4th 5th and 7th word?? output well be: 653 isfbisfb... (2 Replies)
Discussion started by: marvinandco
2 Replies

10. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies
ali(1)							      General Commands Manual							    ali(1)

NAME
ali - list mail aliases (only available within the message handling system, mh) SYNOPSIS
ali [-alias aliasfile] [-help] [-[no]list] [-[no]normalize] [-user useraddr] [-nouser] [aliases...] OPTIONS
Specifies the alias file to be consulted by ali. You can specify more than one alias file, but each aliasfile must be preceded by -alias. In addition to any alias files that you specify, ali consults the system alias file /usr/lib/mh/MailAliases. You can set up an entry in your so that ali automatically consults an alias file. To do this, add the Aliasfile entry to your pro- file. See mh_profile(4) for more information. Prints a list of the valid options to this command. Prints the addresses on separate lines. If you do not specify the -list option, the addresses are separated by commas and printed on as few lines as possible. Instructs ali to try to track down the official hostname of the address. This can be suppressed by using -nonormalize. The default is -nonormalize. Displays all the aliases that contain a specific name. Instead of listing the addresses that each given alias expands to, ali lists the aliases that expand to include each given address. You must specify the complete user name that you have used in your alias file. The defaults for this command are: -alias /usr/lib/mh/MailAliases -nolist -nonormalize -nouser DESCRIPTION
The ali command searches the specified mail alias files for each of the given aliases. It creates a list of addresses for those aliases, and displays that list on the screen. PROFILE COMPONENTS
Location of your mail directory. Location of your personal alias file. EXAMPLES
The following example shows how the -user option can be used to list all the aliases containing the address Parker@Venus: % ali -user Parker@Venus Parker@Venus: Group, Reviewers, Badminton FILES
The user profile. The system alias file. The system password file. The system group file. SEE ALSO
mh-alias(4) ali(1)
All times are GMT -4. The time now is 01:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy