Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help me guys

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help me guys
# 8  
Old 02-11-2013
What result do you get?

--

I tried it on Solaris 10:
Code:
$ /usr/xpg4/bin/awk -F\| '!a[$1,$2]++' infile
USA|Tony|12:25:22:431
USA|John|14:22:42:981
France|Adam|14:22:42:981
Italy|Tony|18:22:42:212

# 9  
Old 02-11-2013
Code:
USA|Tony|12:25:22:431
USA|Tony|14:22:42:981
France|Adam|14:22:42:981
Italy|Tony|18:22:42:212

It's similar to that as I'm using another file with 100k + records it get conflicts , so can u adjust the sort script of u see it

---------- Post updated at 06:40 AM ---------- Previous update was at 06:38 AM ----------

Ok thanks it worked

---------- Post updated at 07:00 AM ---------- Previous update was at 06:40 AM ----------

Can u tell me what it means

Code:
Sort -k1,1 -k3,1r

Last edited by Scrutinizer; 02-11-2013 at 08:08 AM.. Reason: Change slash in closing code tag from backward to forward
# 10  
Old 02-11-2013
I think what you might be looking for is something like this:
Code:
 sort -t"|" -k1,2 -k3,3r infile

The above will sort pipe delimited file starting with field 1 and ending with field 2 ( -k1,2 ) and then sort on field 3 (starting and ending with field 3)in reverse order (-k3,3r).

You can also obtain what you are looking for using awk without sorting. You can sort after if you need final output in sorted order:
Code:
awk 'BEGIN {FS="|"; OFS="|";} ( $3 > array[$1 "," $2] ){ array[$1 "," $2] = $3 } END {for(x in array){split(x,field,","); print field[1], field[2], array[x]}}' infile

This User Gave Thanks to mjf For This Post:
teefa
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Cybersecurity

Hey guys

Hey guys, new geek here, sorry I didnt see a intro section. But I do have a question and hope to make my stay here perma. I am interested in IT security, ands I really want to learn, I was hoping for whatever questions I had you guys could lead me through the narrowest path with a broad selection... (1 Reply)
Discussion started by: abeja
1 Replies

2. Shell Programming and Scripting

Please help me guys...

Hi All! I need to write a script which reads a file and tries to insert into the DB using those values... file format: var1 var2 var3 var4 var5 var6 Now I want to read from the above file and trying to insert like... insert into table1 values( var1, var2, var3 ); in a loop to... (2 Replies)
Discussion started by: games_icon
2 Replies

3. UNIX for Advanced & Expert Users

Please Help Guys Important

Dear All I have an important request: I have a pattern which look like this: 2 20080219_21:43:22.194 ISC-Libya Belgium1 24 IAM 20115139248 218913265641 b 11672 ACM b 20614 CPG b 20619 CPG b 20626 CPG f 33925 REL b 34215 RLC :COMMA: NCI=00,FCI=6001,CPC=0A,TMR=00,USI: :COMMB: BCI=0201:... (15 Replies)
Discussion started by: zanetti321
15 Replies

4. UNIX for Advanced & Expert Users

Please Help Me Guys

Dear All I have a pattern which look like this : 2 20080226_18:02:09.749 ISC-Libya Egypt-Cairo2 111 IAM 2913258040 218927157966 b 61 REL f 143 RLC :COMMA:NCI=10,FCI=6101,CPC=0A,TMR=00,OFI=80,USI: :COMMB:: :RELCAUSE:15: 2 20080226_18:02:11.629 ISC-Libya Egypt-Cairo2 170 IAM 93572641... (8 Replies)
Discussion started by: zanetti321
8 Replies

5. UNIX for Advanced & Expert Users

Hi guys...

I want a Bash Shell Script for taking backup of all files created to day and killing all the Process still active of mine at evening every day (1 Reply)
Discussion started by: vinayraj
1 Replies

6. Shell Programming and Scripting

Help guys!

Hello Guys, I have written the following script to do certain job. I have more than 300 files, all are .pdb & .out files. and the files are (1,3,5,7,11,13,15,17,21,.......787,791,793,795).pdb /.out . But the way I created the for loop in my script works only one file at a time. But that is not... (2 Replies)
Discussion started by: chuchu
2 Replies

7. AIX

Thanks guys

Hi guys, I would like to inform you that I have cleared .... IBM Certified Specialist - p5 and pSeries Administration and Support for AIX 5L V5.3 with 89% thanks to you all. Manu (0 Replies)
Discussion started by: b_manu78
0 Replies

8. UNIX for Dummies Questions & Answers

Hi again guys

actually i have important question about unix / linux i'm working on visuall basic and visuall c++ i heared from someone that i can't open them while i useing unix / linux is that right? if yes .......... what's the solution if no ............. thanks :) :D :D thanks my friends (1 Reply)
Discussion started by: M_Hafez
1 Replies

9. UNIX for Advanced & Expert Users

i need your guys help

HI. I just accidently wipe out my hard drive when i installed sun solaris, this is the last thing i remember, it ask me if want to delete the partition table, and i said yes" Im a retard" i thought solaris can't see xp partition table. Could anyone help me recover my data back, is it really... (21 Replies)
Discussion started by: souldier
21 Replies
Login or Register to Ask a Question