Sponsored Content
Full Discussion: Max value Record from a File
Top Forums Shell Programming and Scripting Max value Record from a File Post 302609917 by traininfa on Wednesday 21st of March 2012 10:08:45 AM
Old 03-21-2012
Max value Record from a File

I have a file with 3 columns

I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them.
Code:
empid,ename,Sal
1,abc,100
2,def,200
3,xyz,300
4,pqr,100
5,mnq,300


Output
Any record with 300 as salary

Moderator's Comments:
Mod Comment Please use next time code tags for your code and data, avoid adding color or different fonts and font size to your posts.


---------- Post updated 03-21-12 at 10:08 AM ---------- Previous update was 03-20-12 at 03:14 PM ----------

I was sorting based on the amount column and then doing a head -1 for the data.Is this the correct approach?

Last edited by vbe; 03-21-2012 at 06:11 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting a record and adding a record to a file

Hi, I am new to UNIX scripting and woiuld appreicate your help... Input file contains only one (but long) record: aaaaabbbbbcccccddddd..... Desired file: NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant# aaaaa bbbbb ccccc ddddd ... ... ... (1 Reply)
Discussion started by: rsolap
1 Replies

2. UNIX for Advanced & Expert Users

Script to search a bad record in a file then put the record in the bad file

I need to write a script that can find a bad record (for example: there is date field colom but value provided in the file for this field is N/A) then script shoud searches this pattern and then insert the whole record into the bad file. Example: File1 Name designation dateOfJoining... (1 Reply)
Discussion started by: shilendrajadon
1 Replies

3. Shell Programming and Scripting

Script to search a bad record in a file then put the record in the bad file

I need to write a script that can find a bad record (for example: there is date field colom but value provided in the file for this field is N/A) then script shoud searches this pattern and then insert the whole record into the bad file. Example: File1 Name designation dateOfJoining... (2 Replies)
Discussion started by: shilendrajadon
2 Replies

4. UNIX for Dummies Questions & Answers

how to read record by record from a file in unix

Hi guys, i have a big file with the following format.This includes header(H),detail(D) and trailer(T) information in the file.My problem is i have to search for the character "6h" at 14 th and 15 th position in all the records .if it is there i have to write all those records into a... (1 Reply)
Discussion started by: raoscb
1 Replies

5. Linux

file-max limit

Oct 31 00:00:02 FIREWALL003 syslogd 1.4.1: restart. Oct 31 00:00:02 FIREWALL003 syslogd 1.4.1: restart. Oct 31 00:00:02 FIREWALL003 syslogd 1.4.1: restart. Oct 31 02:37:09 FIREWALL003 kernel: srmLINUX: segfault at 00000000303a3031 rip 000000000026fe54 rsp 00000000ffbd05b8 error 4 Oct 31... (5 Replies)
Discussion started by: itik
5 Replies

6. Shell Programming and Scripting

Select record with MAX value in MySQL

Hi there, I have trouble selecting record that contain one biggest value for a group of other values. I mean, this is my table: mysql> SELECT * FROM b; +----+------+-------+ | id | user | value | +----+------+-------+ | 1 | 1 | 100 | | 3 | 1 | 150 | | 5 | 1 | 300 | | 6... (20 Replies)
Discussion started by: chebarbudo
20 Replies

7. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

8. Shell Programming and Scripting

Extract timestamp from first record in xml file and it checks if not it will replace first record

I have test.xml <emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp> <Join><id>101</id><city>london</city><date>06/06/14 2011</date></join> <Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join> <Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies

9. Shell Programming and Scripting

Script to record max memory usage of program

Hello, I am working on an application that uses allot of memory depending on the input. I am also working on more than one processing algorithm. The program has a long processing time (hours) so it would be nice to be able to monitor the maximum memory footprint of the application during runs... (1 Reply)
Discussion started by: LMHmedchem
1 Replies
ns_requestauthorize(3aolserver) 			    AOLserver Built-In Commands 			   ns_requestauthorize(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME
ns_requestauthorize - commands SYNOPSIS
ns_requestauthorize option ?arg arg ...? _________________________________________________________________ DESCRIPTION
ns_requestauthorize method URL authuser authpassword ?ipaddr? Ask the server to check permissions using nsperm. This function does the same permission check that the AOLserver does before serving a URL. If the nsperm module is loaded, the algorithm is as follows. 1. If the authuser is "nsadmin", the password is correct, and the IP address of the client is allowed nsadmin access, then access is autho- rized. 2. Find the relevant permission record. If an exact match for the method and URL combination is not found, the end of the URL is pared down until a match is found. For example, if there is no match for `/products/cereals/raisin_bran.html,' then the server looks for a permis- sion record for the URL `/products/cereals.' If that permission record is specified as "Exact URL match is NOT required", then that per- mission record is used. By default, the server comes with a row that says GET on `/' is open to the world. If no relevant permission record is found, access is denied (forbidden). 1. If the authuser is in the "Allow Users" list, access is permitted. If the authuser is a member of a group in the "Allow Groups" list and not in the "Deny Users" list, access is permitted. 2. If the host is in the "Hosts to allow" list, access is permitted. If the host is in the "Hosts to deny" list, access is denied. 3. If the request does not come in with authorization data, access is denied. 4. The user and password are verified. If there is no password specified in the database, any password is accepted. 5. Otherwise, access is denied. Return Values: The following values can be returned by ns_requestauthorize. OK The user has permission to execute this URL and method. DENIED The user does not have permission to execute this URL and method. FORBIDDEN There is no possible user/password/IP Address combination that would give authorization. ERROR There was an error. SEE ALSO
ns_passwordcheck, ns_crypt KEYWORDS
AOLserver 4.0 ns_requestauthorize(3aolserver)
All times are GMT -4. The time now is 09:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy