Sponsored Content
Top Forums Shell Programming and Scripting Computing dataset for a specific record Post 302333941 by ubeejani on Tuesday 14th of July 2009 10:54:24 AM
Old 07-14-2009
Question Computing dataset for a specific record

Hello everybody,
I want to compute a data file in awk. I am new in awk and I need your help. The data file has the following fields. It has thousands of records.

Col1 Col2 Col3 Col4 Col5
0.85 0.07 Fre 42:86 25
0.73 0.03 frp 21:10 28
0.64 0.04 Fre 42:86 63
0.47 0.08 nie 25:76 32
0.37 0.01 veb 00:71 26
0.63 0.48 Fre 42:86 55
0.65 0.32 frp 21:10 19
0.53 0.56 nie 25:76 52
0.32 0.43 veb 00:71 18

Now I want to search this data for every specific record (e.g Fre in column3) and then select the minimum value of that specific record in column5.Consider Col4 as a primary key(unique value for every record).
The output should be like this:

Col1 Col2 Col3 Col4 Col5
0.85 0.07 Fre 42:86 25
0.65 0.32 frp 21:10 19
0.47 0.08 nie 25:76 32
0.32 0.43 veb 00:71 18

Thank you so much for your cooperation.
Regards,
Ubee
 

10 More Discussions You Might Find Interesting

1. Virtualization and Cloud Computing

Event Cloud Computing - IBM Turning Data Centers Into ?Computing Cloud?

Tim Bass Thu, 15 Nov 2007 23:55:07 +0000 *I predict we may experience less*debates*on the use of the term “event cloud”*related to*CEP in the future, now that both IBM and Google* have made announcements about “cloud computing” and “computing cloud”, IBM Turning Data Centers Into ‘Computing... (0 Replies)
Discussion started by: Linux Bot
0 Replies

2. Shell Programming and Scripting

Regarding multiline record searching with specific pattern

Dear Experts, I need to extract specific records from one file which has multiline records. Input file pattern is: ============ aaaaaaaa bbbbbbbb asdf 1234 cccccccc dddddddd ============ aaaaaaaa bbbbbbbb qwer 2345 cccccccc dddddddd (7 Replies)
Discussion started by: dhiraj4mann
7 Replies

3. Solaris

flarecreate for zfs root dataset and ignore multiple dataset

Hi All, I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers. but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate. I... (0 Replies)
Discussion started by: uxravi
0 Replies

4. Shell Programming and Scripting

sed substitution for specific record

Hi, I have a file with two different people, each with there own figure next to it. How would I use a sed command to try and change the correct corresponding value? or is another command more appropriate? I have tried sed -n '/dan/p' money | sed -i 's/1000/1500/g' money the file contents are... (5 Replies)
Discussion started by: somersetdan
5 Replies

5. Shell Programming and Scripting

Get last field specific record

i have file A as below contents --------------------------- Use descriptive thread titles when posting. For example, do not post questions with subjects like "Help Me!", "Urgent!!" or "Doubt". For example, do not post questions For example, do not deliminated. output file as below:... (2 Replies)
Discussion started by: ANSHUMAN1983
2 Replies

6. Shell Programming and Scripting

awk to print record not equal specific pattern

how to use "awk" to print any record has pattern not equal ? for example my file has 5 records & I need to get all lines which $1=10 or 20 , $2=10 or 20 and $3 greater than "130302" as it shown : 10 20 1303252348212B030 20 10 1303242348212B030 40 34 1303252348212B030 10 20 ... (14 Replies)
Discussion started by: arm
14 Replies

7. 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

8. Shell Programming and Scripting

Execution problem with print out record that follow specific pattern

Hi, Do anybody know how to print out only those record that column 1 is "a" , then followed by "b"? Input file : a comp92 2404242 2405172 b comp92 2405303 2406323 b comp92 2408786 2410278 a comp92 2410271 2410337 a comp87 1239833 1240418 b comp87... (3 Replies)
Discussion started by: patrick87
3 Replies

9. Shell Programming and Scripting

Help with print out record if first and next line follow specific pattern

Input file: pattern1 100 250 US pattern2 50 3050 UK pattern3 100 250 US pattern1 70 1050 UK pattern1 170 450 Mal pattern2 40 750 UK . . Desired Output file: pattern1 100 250 US pattern2 50 3050 UK pattern1 170 450 Mal pattern2... (3 Replies)
Discussion started by: cpp_beginner
3 Replies

10. UNIX for Beginners Questions & Answers

Remove footer record in specific condition

Hi Experts, we have a requirement , need your help to remove the footer record in the file. Input file : 1011070375,,21,,NG,NG,asdfsfadf,1011,,30/09/2017,ACI,USD,,0.28,,,,,,,,,,,, 1011070381,,21,,NG,NG,sgfseasdf,1011,,30/09/2017,ACI,GBP,,0.22,,,,,,,,,,,,... (6 Replies)
Discussion started by: KK230689
6 Replies
DateTime::Locale::de_BE(3)				User Contributed Perl Documentation				DateTime::Locale::de_BE(3)

NAME
DateTime::Locale::de_BE SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'de_BE' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for German Belgium. DATA
This locale inherits from the DateTime::Locale::de locale. It contains the following data. Days Wide (format) Montag Dienstag Mittwoch Donnerstag Freitag Samstag Sonntag Abbreviated (format) Mon Die Mit Don Fre Sam Son Narrow (format) Mon Die Mit Don Fre Sam Son Wide (stand-alone) Montag Dienstag Mittwoch Donnerstag Freitag Samstag Sonntag Abbreviated (stand-alone) Mon Die Mit Don Fre Sam Son Narrow (stand-alone) M D M D F S S Months Wide (format) Januar Februar Maerz April Mai Juni Juli August September Oktober November Dezember Abbreviated (format) Jan Feb Maer Apr Mai Jun Jul Aug Sep Okt Nov Dez Narrow (format) J F M A M J J A S O N D Wide (stand-alone) Januar Februar Maerz April Mai Juni Juli August September Oktober November Dezember Abbreviated (stand-alone) Jan Feb Maer Apr Mai Jun Jul Aug Sep Okt Nov Dez Narrow (stand-alone) J F M A M J J A S O N D Quarters Wide (format) 1. Quartal 2. Quartal 3. Quartal 4. Quartal Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) 1. Quartal 2. Quartal 3. Quartal 4. Quartal Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide v. Chr. n. Chr. Abbreviated v. Chr. n. Chr. Narrow v. Chr. n. Chr. Date Formats Full 2008-02-05T18:30:30 = Dienstag 5 Februar 2008 1995-12-22T09:05:02 = Freitag 22 Dezember 1995 -0010-09-15T04:44:23 = Samstag 15 September -10 Long 2008-02-05T18:30:30 = 5 Februar 2008 1995-12-22T09:05:02 = 22 Dezember 1995 -0010-09-15T04:44:23 = 15 September -10 Medium 2008-02-05T18:30:30 = 05.02.2008 1995-12-22T09:05:02 = 22.12.1995 -0010-09-15T04:44:23 = 15.09.-010 Short 2008-02-05T18:30:30 = 5/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = 05.02.2008 1995-12-22T09:05:02 = 22.12.1995 -0010-09-15T04:44:23 = 15.09.-010 Time Formats Full 2008-02-05T18:30:30 = 18 h 30 min 30 s UTC 1995-12-22T09:05:02 = 09 h 05 min 02 s UTC -0010-09-15T04:44:23 = 04 h 44 min 23 s UTC Long 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Datetime Formats Full 2008-02-05T18:30:30 = Dienstag 5 Februar 2008 18 h 30 min 30 s UTC 1995-12-22T09:05:02 = Freitag 22 Dezember 1995 09 h 05 min 02 s UTC -0010-09-15T04:44:23 = Samstag 15 September -10 04 h 44 min 23 s UTC Long 2008-02-05T18:30:30 = 5 Februar 2008 18:30:30 UTC 1995-12-22T09:05:02 = 22 Dezember 1995 09:05:02 UTC -0010-09-15T04:44:23 = 15 September -10 04:44:23 UTC Medium 2008-02-05T18:30:30 = 05.02.2008 18:30:30 1995-12-22T09:05:02 = 22.12.1995 09:05:02 -0010-09-15T04:44:23 = 15.09.-010 04:44:23 Short 2008-02-05T18:30:30 = 5/02/08 18:30 1995-12-22T09:05:02 = 22/12/95 09:05 -0010-09-15T04:44:23 = 15/09/-10 04:44 Default 2008-02-05T18:30:30 = 05.02.2008 18:30:30 1995-12-22T09:05:02 = 22.12.1995 09:05:02 -0010-09-15T04:44:23 = 15.09.-010 04:44:23 Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 Ed (E d.) 2008-02-05T18:30:30 = Die 5. 1995-12-22T09:05:02 = Fre 22. -0010-09-15T04:44:23 = Sam 15. EEEd (d. EEE) 2008-02-05T18:30:30 = 5. Die 1995-12-22T09:05:02 = 22. Fre -0010-09-15T04:44:23 = 15. Sam H (H) 2008-02-05T18:30:30 = 18 1995-12-22T09:05:02 = 9 -0010-09-15T04:44:23 = 4 HHmm (HH:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 HHmmss (HH:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 nachm. 1995-12-22T09:05:02 = 9:05 vorm. -0010-09-15T04:44:23 = 4:44 vorm. Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 nachm. 1995-12-22T09:05:02 = 9:05:02 vorm. -0010-09-15T04:44:23 = 4:44:23 vorm. M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (d.M.) 2008-02-05T18:30:30 = 5.2. 1995-12-22T09:05:02 = 22.12. -0010-09-15T04:44:23 = 15.9. MEd (E, d.M.) 2008-02-05T18:30:30 = Die, 5.2. 1995-12-22T09:05:02 = Fre, 22.12. -0010-09-15T04:44:23 = Sam, 15.9. MMd (d.MM.) 2008-02-05T18:30:30 = 5.02. 1995-12-22T09:05:02 = 22.12. -0010-09-15T04:44:23 = 15.09. MMdd (dd.MM.) 2008-02-05T18:30:30 = 05.02. 1995-12-22T09:05:02 = 22.12. -0010-09-15T04:44:23 = 15.09. MMM (LLL) 2008-02-05T18:30:30 = Feb 1995-12-22T09:05:02 = Dez -0010-09-15T04:44:23 = Sep MMMd (d. MMM) 2008-02-05T18:30:30 = 5. Feb 1995-12-22T09:05:02 = 22. Dez -0010-09-15T04:44:23 = 15. Sep MMMEd (E d. MMM) 2008-02-05T18:30:30 = Die 5. Feb 1995-12-22T09:05:02 = Fre 22. Dez -0010-09-15T04:44:23 = Sam 15. Sep MMMMd (d MMMM) 2008-02-05T18:30:30 = 5 Februar 1995-12-22T09:05:02 = 22 Dezember -0010-09-15T04:44:23 = 15 September MMMMdd (dd. MMMM) 2008-02-05T18:30:30 = 05. Februar 1995-12-22T09:05:02 = 22. Dezember -0010-09-15T04:44:23 = 15. September MMMMEd (E d. MMMM) 2008-02-05T18:30:30 = Die 5. Februar 1995-12-22T09:05:02 = Fre 22. Dezember -0010-09-15T04:44:23 = Sam 15. September mmss (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (yyyy-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -010-9 yMEd (EEE, yyyy-M-d) 2008-02-05T18:30:30 = Die, 2008-2-5 1995-12-22T09:05:02 = Fre, 1995-12-22 -0010-09-15T04:44:23 = Sam, -010-9-15 yMMM (MMM y) 2008-02-05T18:30:30 = Feb 2008 1995-12-22T09:05:02 = Dez 1995 -0010-09-15T04:44:23 = Sep -10 yMMMEd (EEE, d. MMM y) 2008-02-05T18:30:30 = Die, 5. Feb 2008 1995-12-22T09:05:02 = Fre, 22. Dez 1995 -0010-09-15T04:44:23 = Sam, 15. Sep -10 yMMMM (MMMM y) 2008-02-05T18:30:30 = Februar 2008 1995-12-22T09:05:02 = Dezember 1995 -0010-09-15T04:44:23 = September -10 yQ (Q yyyy) 2008-02-05T18:30:30 = 1 2008 1995-12-22T09:05:02 = 4 1995 -0010-09-15T04:44:23 = 3 -010 yQQQ (QQQ y) 2008-02-05T18:30:30 = Q1 2008 1995-12-22T09:05:02 = Q4 1995 -0010-09-15T04:44:23 = Q3 -10 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyMMdd (dd.MM.yy) 2008-02-05T18:30:30 = 05.02.08 1995-12-22T09:05:02 = 22.12.95 -0010-09-15T04:44:23 = 15.09.-10 yyMMM (MMM yy) 2008-02-05T18:30:30 = Feb 08 1995-12-22T09:05:02 = Dez 95 -0010-09-15T04:44:23 = Sep -10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyQQQQ (QQQQ yy) 2008-02-05T18:30:30 = 1. Quartal 08 1995-12-22T09:05:02 = 4. Quartal 95 -0010-09-15T04:44:23 = 3. Quartal -10 yyyy (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = Februar 2008 1995-12-22T09:05:02 = Dezember 1995 -0010-09-15T04:44:23 = September -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week Montag SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.3 2014-06-10 DateTime::Locale::de_BE(3)
All times are GMT -4. The time now is 12:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy