Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Sort data As per first Column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sort data As per first Column
# 1  
Old 02-26-2012
Bug Sort data As per first Column
hI

I have file A

Code:
NSU30504 5 6 G 6  
NSU3050B T 7 9 J
NSU30506 T I 8 9 
NSU3050C H J K L

Output:

Code:
NSU3050B T 7 9 J
NSU3050C H J K L 
NSU30504 5 6 G 6  
NSU30506 T I 8 9

Moderator's Comments:
Mod Comment Video tutorial on how to use code tags in The UNIX and Linux Forums.
Last edited by radoulov; 02-26-2012 at 05:31 AM..
# 2  
Old 02-26-2012
If I understand the question correctly, with recent GNU sort implementations:

Code:
sort -V infile

This User Gave Thanks to radoulov For This Post:
Scrutinizer
# 3  
Old 02-26-2012
simply sort it ..

Code:
sort -n FileA

# 4  
Old 02-26-2012
it's not helping me ...

I am using shell scripting//

Solaris...

---------- Post updated at 04:17 AM ---------- Previous update was at 03:49 AM ----------

Data should be short as per column A (First Column)
# 5  
Old 02-26-2012
Try:

Code:
perl -lane'
  push @d, [$_, $F[0] =~ /(\D)+$/, "z"];
  END {
    print join $/, map $_->[0], sort {
      $a->[1] cmp $b->[1] ||
        $a->[0] <=> $b->[0]
      } @d
    }' infile

# 6  
Old 02-26-2012
Quote:
Originally Posted by pareshkp
Data should be short as per column A (First Column)
You actually mean sort (not short), don't you?
# 7  
Old 02-26-2012
Its working and also i want sort my data as per column B if it is possible ?


Input:
Code:
NSU30504 5 6 G 6  
NSU3050B 1 7 9 J
NSU30506 4 I 8 9 
NSU3050C 9 J K L

Output:

Code:
NSU3050B 1 7 9 J
NSU30506 4 I 8 9 
NSU30504 5 6 G 6 
NSU3050C 9 J K L

Thanks

---------- Post updated at 04:47 AM ---------- Previous update was at 04:37 AM ----------

Sorry man sort data in ascending order//
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies

2. UNIX for Beginners Questions & Answers

How do I sort data in column properly?

Can i use 'column' command to get the required 3rd column output? Input example: 1 2 345678 90 2 2 356 42 3 3 8265 55 Output required: 1 2 345678 90 2 2 356 42 3 3 8265 55 Basically i want the 3rd column to be justified to the right, instead of left.... (3 Replies)
Discussion started by: nurul_nadzirah
3 Replies

3. Shell Programming and Scripting

Help with sort only column 2 data separately

Input File Contig_1_294435nt 242231 242751 Contig_1_294435nt 242390 242782 Contig_1_294435nt 242390 242782 Contig_1_294435nt 291578 291668 Contig_2_242278nt 75910 76271 Contig_2_242278nt 76036 76316 Contig_2_242278nt 76036 76316... (2 Replies)
Discussion started by: perl_beginner
2 Replies

4. Shell Programming and Scripting

Sort data by date and then search by column

Hi, I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates. NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Discussion started by: samrat dutta
2 Replies

5. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 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... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

6. Shell Programming and Scripting

Advanced: Sort, count data in column, append file name

Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out. I have several text files that contain data in many columns. All the files are organized the same... (14 Replies)
Discussion started by: JamesT
14 Replies

7. Shell Programming and Scripting

Sort data from column to row

Hi, I need somebody's help with sorting data with awk. I've got a file: 10 aaa 4584 12 bbb 6138 20 ccc 4417 21 ddd 7796 10 eee 7484 12 fff ... (5 Replies)
Discussion started by: killerbee
5 Replies

8. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just... (7 Replies)
Discussion started by: ckaramsetty
7 Replies

9. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

10. Shell Programming and Scripting

Question about sort specific column and print other column at the same time !

Hi, This is my input file: ali 5 usa abc abu 4 uk bca alan 6 brazil bac pinky 10 utah sdc My desired output: 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... (3 Replies)
Discussion started by: patrick87
3 Replies
Login or Register to Ask a Question