SORT problem on SUN


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers SORT problem on SUN
# 1  
Old 06-29-2006
SORT problem on SUN

Hello,

I tried to sort on column2 followed by column1 and notice how the "updated" value in column1 is not sorted correctly!

Can you tell me if i have the sort statement setup correctly please, thanks much!


sort -t "|" -k2 -k1 sortin > sortout


caller|wf_item|WF_ITEM.doc|Create_Item|Item_Exist|516
caller|wf_item|WF_ITEM.doc|Create_Item|Item_Exist|517
caller|WF_ITEM|WF_ITEM.doc||in|7
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|162
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|163
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|172
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|200
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|201
caller|WF_ITEM|WF_ITEM.doc|InitCache|SetEndDate|205
caller|Wf_Item|WF_ITEM.doc|Root_Process|Item_Exist|444
caller|wf_item|WF_ITEM.doc|Root_Process|Item_Exist|445
caller|wf_item|WF_ITEM.doc|Root_Process|Item_Exist|446
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|383
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|384
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|385
caller|Wf_Item|WF_ITEM.doc|SetItemU
# 2  
Old 06-29-2006
Code:
 sort -t'|' -k 2.1,2.10 -k 1.1,1.10 filename

output
Code:
caller|WF_ITEM|WF_ITEM.doc|InitCache|SetEndDate|205
caller|WF_ITEM|WF_ITEM.doc||in|7
caller|Wf_Item|WF_ITEM.doc|Root_Process|Item_Exist|444
caller|Wf_Item|WF_ITEM.doc|SetItemU
caller|wf_item|WF_ITEM.doc|Create_Item|Item_Exist|516
caller|wf_item|WF_ITEM.doc|Create_Item|Item_Exist|517
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|162
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|163
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|172
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|200
caller|wf_item|WF_ITEM.doc|InitCache|SetEndDate|201
caller|wf_item|WF_ITEM.doc|Root_Process|Item_Exist|445
caller|wf_item|WF_ITEM.doc|Root_Process|Item_Exist|446
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|383
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|384
caller|wf_item|WF_ITEM.doc|SetItemUserKey|GetItemUserKey|385
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|194
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195
ubdated|wf_item|WF_ITEM.doc|InitCache|SetEndDate|195

# 3  
Old 06-29-2006
Thanks a lot Jim for the help!

that did the trick!

Spent hours on that without any progress!

Have a great 4th Jim!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sort problem!

Hi, I have a file having content: 123 123 1234 12131 121 23 1212 1212121 23421 1212 1213123 I want to remove the repeated lines from it, i.e. I just want the any number just one time without any sorting in it. The problem is that I am not getting result from 'uniq' command. as... (2 Replies)
Discussion started by: nixhead
2 Replies

2. UNIX for Advanced & Expert Users

Problem with sort +4

Apologies if this should be in 'unix for dummies' thread.. I have a large file containing records like this: 16 Feb 02:49 s_A123_ctas_log.20100216024000.bin 26 Feb 02:55 s_B123_ctas_log.20100226024000.bin 05 Mar 05:22 s_A127_ctas_log.20100305024000.bin I want to sort it by column 4... (2 Replies)
Discussion started by: Grueben
2 Replies

3. Shell Programming and Scripting

problem with sort

Hi all, i want to sort by the (1-8) columns and (9-7) columns: my file: MARTINEZ---PAUL --DUPOND---EDDY --DURANDJACQUES --DUPOND--ALAIN output: --DUPOND--ALAIN --DUPOND---EDDY --DURANDJACQUES MARTINEZ---PAUL (6 Replies)
Discussion started by: saw7
6 Replies

4. UNIX for Dummies Questions & Answers

Problem with sort-of array in SH

Hello to everyone! I'm really new in shell scripting and I'm experiencing a very odd problem. This is my first post in this forum, hope you can help! I know that declaring arrays in Bourne Shell is impossible. But this is where I start having problems - system administrator did not install... (8 Replies)
Discussion started by: onstock
8 Replies

5. Programming

sort problem

I am in need of some direction. First off I want to admit this is an assignment but I have hit a block. I need to sort, by the number of times a string occurs (count), and output the top 10. I have found what number gives me the top 10 so from there I need to know how to sort them. Any... (1 Reply)
Discussion started by: Cn00b
1 Replies

6. Shell Programming and Scripting

sort order HP UX / SUN Solaris

Hi! simple 'sort' produces a different output on SUN OS than on HP. Lines with empty fields inside the key are sorted at the beginning on SUN; on HP they are at the end. i.e SUN 03|ref|168126310|702578641|||||||||||||| 03|ref|168126310|702578641|DEL| 03|ref|168126310|702578641|FW|... (5 Replies)
Discussion started by: strolchFX
5 Replies

7. AIX

sort and dedup problem

I have a file with contents: 1|4|oho hosfadu| 1|3|sdfsd fds| 2|2|sdfg| 2|1|sdf a| 3|5|ouhuh hu| I would like to do three things to it; 1- first, sort it on the first two fields 2- get a unique count on the first field 3- and write the first two unique rows (uniqueness based off the... (4 Replies)
Discussion started by: ChicagoBlues
4 Replies

8. Shell Programming and Scripting

sort problem

I have file (srv_lst) with the contents as ... 9.2 IRMD115 8.1 IRMD115 and I am using the sort as to get the bigger version as : sort -r -u +1 $srv_lst | sort -k 1,1r and the output is 9.2 which is good .. if I have the contents of file srv_lst as : 9.2 IRMD115 10.2 IRMD115 ... (4 Replies)
Discussion started by: talashil
4 Replies

9. Shell Programming and Scripting

how to use awk to sort this problem out

there has several numbers which are:1,2,3,45,6,7,8,9,0,10,34,34,54,122,6756,54,87,99,2,1,45; how to write a shell script orts the above numbers into descending order and puts them into and arrray and also find and prints the minimum and maximum of those numbers, and finds and prints the average... (4 Replies)
Discussion started by: sonicstage
4 Replies

10. UNIX for Dummies Questions & Answers

Problem with sort

I am attempting to sort a file using the following command: sort +0 -t"|" infilename > outfilename I am getting the following error: sort: 0653-657 A write error occurred while sorting. The file size is 15036274 bytes This is an AIX 5.2 version I believe this is a problem with the... (1 Reply)
Discussion started by: jyoung
1 Replies
Login or Register to Ask a Question