Find highest records in table Post: 302828549

Sponsored Content

Top Forums Shell Programming and Scripting Find highest records in table Post 302828549 by Don Cragun on Tuesday 2nd of July 2013 04:10:45 PM

07-02-2013

Registered User

Quote:

Originally Posted by GDC

Dear Don Cragun,

thanks for point out the missing value for one of the sensor. Finding the best values for each sensor is part of a larger script and at the end a few sensors have to be removed.

The list is concatenated and therefore the sensors are not sorted. I could, however, add a extra step to sort the file first.

Thanks for your suggestions!

I wasn't sure if sensor M01072-5 was missing or if sensor M01072-4 was there by mistake. You originally said that there would be three to six measurements per sensor and both of these sensors only had two measurements in your sample data.

Sorting your input file takes time and might rearrange the order of lines that have the same sort key, so if picking the 1st measurement from measurements with the same calculated "best" measurement matters, Yoda's suggestion is probably much better than sorting and then using a simpler awk script.

The script rdrtx1 just provided also looks good as long as none of your sensor reading calculations ($6 * $7) produce negative values.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

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

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

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

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

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

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>

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

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

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

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

LEARN ABOUT DEBIAN

device::usb::pcsensor::hidtemper::sensor

Device::USB::PCSensor::HidTEMPer::Sensor(3pm)		User Contributed Perl Documentation	     Device::USB::PCSensor::HidTEMPer::Sensor(3pm)

       Device::USB::PCSensor::HidTEMPer::Sensor - Generic sensor class

VERSION

       Version 0.02

SYNOPSIS

       None

DESCRIPTION

       This module contains a generic class that all HidTEMPer sensors should inherit from keeping the implemented methods consistent, and making
       it possible to use the same code to contact every supported device.

   CONSTANTS
       o  MAX_TEMPERATURE

	  The highest temperature(Celsius) this sensor can detect.

       o  MIN_TEMPERATURE

	  The lowest temperature(Celsius) this sensor can detect.

   METHODS
       o  new( $device )

	  Generic initializing method, creating a sensor object.

	  Input parameter

	  $device = A pre-initialized Device::USB::PCSensor::HidTEMPer::Device that the sensor is connected to. This device will be used to handle
	  communication.

       o  fahrenheit()

	  Reads the current temperature and returns the corresponding value in fahrenheit degrees.

       o  max()

	  Returns the highest temperature(Celsius) the sensor can detect.

       o  min()

	  Returns the lowest temperature(Celsius) the sensor can detect.

       o  celsius()

	  Empty method that should be implemented in each sensor, returing the current degrees in celsius.

DEPENDENCIES

       This module internally includes and takes use of the following packages:

	 use Scalar::Util qw/ weaken /;

       This module uses the strict and warning pragmas.

BUGS

       Please report any bugs or missing features using the CPAN RT tool.

FOR MORE INFORMATION

       None

AUTHOR

       Magnus Sulland < msulland@cpan.org >

ACKNOWLEDGEMENTS

       None

COPYRIGHT &; LICENSE
       Copyright (c) 2010 Magnus Sulland

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.1							    2010-07-24			     Device::USB::PCSensor::HidTEMPer::Sensor(3pm)