Sponsored Content
Top Forums Shell Programming and Scripting Find highest records in table Post 302828435 by Yoda on Tuesday 2nd of July 2013 12:21:53 PM
Old 07-02-2013
Code:
awk '
        {
                $1 = $1
                V = $6 * $7
                if ( $1 in A )
                {
                        if ( A[$1] < V )
                        {
                                A[$1] = V
                                R[$1] = $0 OFS V
                        }
                }
                else
                {
                        A[$1] = V
                        R[$1] = $0 OFS V
                }
        }
        END {
                for ( k in R )
                        print R[k]
        }
' OFS='\t' file

This User Gave Thanks to Yoda For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

find the highest number in the file

Hi, I have a file a.txt and it has values in it Eg :- I need to read through the file and find the number that is the greatest in them all. Can any one assit me on this. Thanks (30 Replies)
Discussion started by: systemali
30 Replies

2. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

3. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann (1 Reply)
Discussion started by: Haque123
1 Replies

4. Shell Programming and Scripting

Verifying table records

Hi, Script copies records of two tables into another tables for backup before using oracle's import utility to restore from backup. Now, suppose if the import utility fails then the script will again copy those records from the backup table to the original ones. How to check whether all... (2 Replies)
Discussion started by: milink
2 Replies

5. Shell Programming and Scripting

Total records in table

Hi, I am having two tables. A & B I want to know the total number of records in each table and need to store each value in some variables to process further in the code. How it can be done ? With Regards (2 Replies)
Discussion started by: milink
2 Replies

6. Programming

Help with find highest and smallest number in a file with c

Input file: #data_1 AGDG #data_2 ADG #data_3 ASDDG DG #data_4 A Desired result: Highest 7 Slowest 1 code that I try but failed to archive my goal :( #include <stdio.h> (2 Replies)
Discussion started by: cpp_beginner
2 Replies

7. Shell Programming and Scripting

Getting number of records from a table

I am doing a loading process. I am loading data from a Oracle source to Oracle target. For example there is an SQL statement: Insert into emp_1 Select * from emp_2 where deptno=20; In this case my source is emp_2 and loading into my target table emp_1. This process is automated. Now I... (3 Replies)
Discussion started by: karthikkasarla
3 Replies

8. Shell Programming and Scripting

Find highest number - working but need help!

Hello all, I am new to this and need some help or maybe steer me to the right direction! I wrote a script to get the highest number and prints it on the screen, the script basically asks the user to input numbers, and then prints the highest number! very simple it works like this $sh max.sh... (8 Replies)
Discussion started by: unknownsolo
8 Replies

9. Shell Programming and Scripting

Delete the records from table

Hi, Can any one help me... the records are not deleting when I run the below script. But if I issue the same delete command manually, the records are getting deleted. script: #!/bin/ksh USAGE_STRING="USAGE $0 " if then echo "SORRY you need to be user 'mqm'. Only 'mqm' has... (5 Replies)
Discussion started by: zxcjggu708
5 Replies

10. Solaris

Find highest value of a particular property in multiple files

I have multiple files with pattern of "*.tps (example:tps-20170307170421560-1053.tps)" in my log directory(files are in different sub directories). entries in files are given below. I want to extract highest value of endtime accross all files. "endTime :1488902691462" ... (7 Replies)
Discussion started by: Agoyals1986
7 Replies
SWSENSOR(4)						   BSD Kernel Interfaces Manual 					       SWSENSOR(4)

NAME
swsensor -- software environmental sensor SYNOPSIS
pseudo-device swsensor DESCRIPTION
The swsensor driver provides a software environmental sensor that works with sysctl(8) and envstat(8). The driver is intended to be loaded as a kernel module. One can, however, include the swsensor driver directly in a kernel using the configuration from the synopsis. By default, the sensor is of type ENVSYS_UNITS_INTEGER. The following values can be specified in the modload(8) command when loading the swsensor module to alter the driver's behavior. Variable Usage mode Controls whether or not swsensor provides internally-maintained limits and limit checking Value Meaning 0 sensor has no internally-maintained limits 1 sensor provides its own internal limit value 2 sensor maintains an internal adjustable limit and performs its own comparison between the sensor's limit and its current value limit The initial alarm limit value, if limit emulation is selected (i.e., if mode is set to 1 or 2) value_max value_min The maximum and minimum values. The corresponding ENVSYS_FVALID_MAX and ENVSYS_FVALID_MIN flags are implicitly set. percentage This boolean value controls the setting of the ENVSYS_FPERCENT flag. type Define the sensor's unit/type. By default, a Temperature sensor is created. Any of the string values from the following table can be specified: Temperature Fan Voltage AC Voltage DC Ohms Watts Ampere Watt hour Ampere hour Indicator Integer Drive Battery capacity Battery charge (Values are case-sensitive, and spaces must be included.) value Provide an initial value for the sensor. If this is omitted, the sensor's initial value is set to zero. For example, modload -s type=Voltage DC swsensor will create a sensor of type ENVSYS_UNITS_SVOLTS_DC, while modload -i mode=1 -i limit=50 swsensor will create a sensor which has an initial, device-provided limit of 50. The sensor's raw value and state can be manually updated by modifying the sysctl(8) variables ``hw.swsensor.cur_value'' and ``hw.swsensor.state'' variables respectively. SEE ALSO
modctl(2), envstat(8), sysctl(8) HISTORY
The swsensor driver was written by Paul Goyette and first appeared in NetBSD 6.0. BUGS
The swsensor driver emulates a device with only a single sensor. The swsensor driver can only emulate one hardware-managed limit; this is assumed to be the critical-min limit. BSD
August 27, 2012 BSD
All times are GMT -4. The time now is 10:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy