Sponsored Content
Top Forums Shell Programming and Scripting How to compare a field value of a same column? Post 302198973 by gobinath on Sunday 25th of May 2008 10:24:38 AM
Old 05-25-2008
Thanks for your immediate response....

I need the output like this,

Time diff of 122 : (10:29:09.97-10:29:07.32) = 00:00:02.65
Time diff of 124 : (10:29:09.97-10:29:07.35) = 00:00:02.65
Time diff of 128: (10:29:19.12-10:29:18.66) = 00:00:00:46
Time diff of 148:
Time diff of 156:
Time diff of 167:
================================================
Consolidated time diff= 00:00:05:76

Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare files column to column based on keys

Here is my situation. I need to compare two tab separated files (diff is not useful since there could be known difference between files). I have found similar posts , but not fully matching.I was thinking of writing a shell script using cut and grep and while loop but after going thru posts it... (2 Replies)
Discussion started by: blackjack101
2 Replies

2. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ... (6 Replies)
Discussion started by: popesk
6 Replies

3. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

4. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

5. Shell Programming and Scripting

Compare a common field in two files and append a column from File 1 in File2

Hi Friends, I am new to Shell Scripting and need your help in the below situation. - I have two files (File 1 and File 2) and the contents of the files are mentioned below. - "Application handle" is the common field in both the files. (NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Discussion started by: Santoshbn
2 Replies

6. Shell Programming and Scripting

Compare two files Field by field and output the result in another file

Hi Friends, Need Help. I have file1.txt as File1.txt |123|A|7267|Hyder|Cross|Sell|7801 |995|A|7051|2008|Lunar|New|Year|Promotion|7801 |996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801 |997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801 File2.txt... (7 Replies)
Discussion started by: i150371485
7 Replies

7. Shell Programming and Scripting

Plz Help. Compare 2 files field by field and get the output in another file.

Hi Freinds, I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output. Source.txt 1|HYD|NAG|TRA|34.5|1234 2|CHE|ESW|DES|36.5|134 3|BAN|MEH|TRA|33.5|234... (5 Replies)
Discussion started by: i150371485
5 Replies

8. UNIX for Dummies Questions & Answers

Compare data - Match first column and compare second

Hi guys, looking for some help with a way to compare data in two files but with some conditions. example, File 1 consists of site1,10.1.1.1 site2,20.2.2.2 site3,30.3.3.3 File 2 contains site1,l0.1.1.1 site2,50.1.1.1 site3,30.3.3.3 site4,40.1.1.1 I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies

9. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

10. UNIX for Beginners Questions & Answers

UNIX script to compare 3rd column value with first column and display

Hello Team, My source data (INput) is like below EPIC1 router EPIC2 Targetdefinition Exp1 Expres rtr1 Router SQL SrcQual Exp1 Expres rtr1 Router EPIC1 Targetdefinition My output like SQL SrcQual Exp1 Expres Exp1 Expres rtr1 Router rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies
Bad(3pm)						User Contributed Perl Documentation						  Bad(3pm)

NAME
PDL::Bad - PDL does process bad values DESCRIPTION
PDL has been compiled with WITH_BADVAL set to 1. Therefore, you can enter the wonderful world of bad value support in PDL. This module is loaded when you do "use PDL", "Use PDL::Lite" or "PDL::LiteF". Implementation details are given in PDL::BadValues. SYNOPSIS
use PDL::Bad; print " Bad value support in PDL is turned " . $PDL::Bad::Status ? "on" : "off" . ". "; Bad value support in PDL is turned on. and some other things VARIABLES
There are currently three variables that this module defines which may be of use. $PDL::Bad::Status Set to 1 $PDL::Bad::UseNaN Set to 1 if PDL was compiled with "BADVAL_USENAN" set, 0 otherwise. $PDL::Bad::PerPdl Set to 1 if PDL was compiled with the experimental "BADVAL_PER_PDL" option set, 0 otherwise. FUNCTIONS
badflag switch on/off/examine bad data flag if ( $a->badflag() ) { print "Data may contain bad values. "; } $a->badflag(1); # set bad data flag $a->badflag(0); # unset bad data flag A return value of 1 does not guarantee the presence of bad data in a piddle; all it does is say that we need to check for the presence of such beasties. To actually find out if there are any bad values present in a piddle, use the check_badflag method. Does support bad values. badvalue returns the value used to indicate a missing (or bad) element for the given piddle type. You can give it a piddle, a PDL::Type object, or one of $PDL_B, $PDL_S, etc. $badval = badvalue( float ); $a = ones(ushort,10); print "The bad data value for ushort is: ", $a->badvalue(), " "; If a new value is supplied via a piddle (e.g. "$a->badvalue(23)"), then the data in the supplied piddle is converted to use the new bad value as well if the data type is an integer or "$PDL::Bad::UseNaN == 0". Currently there is no way of automatically converting the bad values of already existing piddles. This could be supported - e.g. by having a per-piddle bad value or by storing a time index in the piddle structure - if required. If the $PDL::Bad::PerPdl flag is set then it is possible to change the bad value on a per-piddle basis, so $a = sequence(10); $a->badvalue(3); $a->badflag(1); $b = sequence(10); $b->badvalue(4); $b->badflag(1); will set $a to be "[0 1 2 BAD 4 5 6 7 8 9]" and $b to be "[0 1 2 3 BAD 5 6 7 8 9]". If the flag is not set then both $a and $b will be set to "[0 1 2 3 BAD 5 6 7 8 9]". Please note that the code to support per-piddle bad values is experimental in the current release. Does support bad values. orig_badvalue returns the original value used to represent bad values for a given type. This routine operates the same as badvalue, except you can not change the values. It also has an awful name. $orig_badval = orig_badvalue( float ); $a = ones(ushort,10); print "The original bad data value for ushort is: ", $a->orig_badvalue(), " "; Does support bad values. check_badflag clear the bad-value flag of a piddle if it does not contain any bad values Given a piddle whose bad flag is set, check whether it actually contains any bad values and, if not, clear the flag. It returns the final state of the bad-value flag. print "State of bad flag == ", $pdl->check_badflag; Does support bad values. isbad Signature: (a(); int [o]b()) Is a value bad? Returns a 1 if the value is bad, 0 otherwise. Also see isfinite. $a = pdl(1,2,3); $a->badflag(1); set($a,1,$a->badvalue); $b = isbad($a); print $b, " "; [0 1 0] isbad does handle bad values. The output piddles will NOT have their bad-value flag set. isgood Signature: (a(); int [o]b()) Is a value good? Returns a 1 if the value is good, 0 otherwise. Also see isfinite. $a = pdl(1,2,3); $a->badflag(1); set($a,1,$a->badvalue); $b = isgood($a); print $b, " "; [1 0 1] isgood does handle bad values. The output piddles will NOT have their bad-value flag set. nbadover Signature: (a(n); int+ [o]b()) Find the number of bad elements along the 1st dimension. This function reduces the dimensionality of a piddle by one by finding the number of bad elements along the 1st dimension. By using xchg etc. it is possible to use any dimension. $a = nbadover($b); $spectrum = nbadover $image->xchg(0,1) nbadover does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. ngoodover Signature: (a(n); int+ [o]b()) Find the number of good elements along the 1st dimension. This function reduces the dimensionality of a piddle by one by finding the number of good elements along the 1st dimension. By using xchg etc. it is possible to use any dimension. $a = ngoodover($b); $spectrum = ngoodover $image->xchg(0,1) ngoodover does handle bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. setbadat Set the value to bad at a given position. setbadat $piddle, @position @position is a coordinate list, of size equal to the number of dimensions in the piddle. This is a wrapper around set and is probably mainly useful in test scripts! pdl> $x = sequence 3,4 pdl> $x->setbadat 2,1 pdl> p $x [ [ 0 1 2] [ 3 4 BAD] [ 6 7 8] [ 9 10 11] ] Supports badvalues. setbadif Signature: (a(); int mask(); [o]b()) Set elements bad based on the supplied mask, otherwise copy across the data. $a = sequence(5,5); $a = $a->setbadif( $a % 2 ); print "a badflag: ", $a->badflag, " "; a badflag: 1 Unfortunately, this routine can not be run inplace, since the current implementation can not handle the same piddle used as "a" and "mask" (eg "$a->inplace->setbadif($a%2)" fails). Also see setvaltobad and setnantobad. The output always has its bad flag set, even if it does not contain any bad values (use check_badflag to check whether there are any bad values in the output). Any bad values in the input piddles are copied across to the output piddle. setvaltobad Signature: (a(); [o]b(); double value) Set bad all those elements which equal the supplied value. $a = sequence(10) % 3; $a->inplace->setvaltobad( 0 ); print "$a "; [BAD 1 2 BAD 1 2 BAD 1 2 BAD] This is a simpler version of setbadif, but this function can be done inplace. See setnantobad if you want to convert NaN/Inf to the bad value. The output always has its bad flag set, even if it does not contain any bad values (use check_badflag to check whether there are any bad values in the output). Any bad values in the input piddles are copied across to the output piddle. setnantobad Signature: (a(); [o]b()) Sets NaN/Inf values in the input piddle bad (only relevant for floating-point piddles). Can be done inplace. $b = $a->setnantobad; $a->inplace->setnantobad; Supports bad values. setbadtonan Signature: (a(); [o]b()) Sets Bad values to NaN (only relevant for floating-point piddles). Can be done inplace and it clears the bad flag. $b = $a->setbadtonan; $a->inplace->setbadtonan; Supports bad values. setbadtoval Signature: (a(); [o]b(); double newval) Replace any bad values by a (non-bad) value. Can be done inplace. Also see badmask. $a->inplace->setbadtoval(23); print "a badflag: ", $a->badflag, " "; a badflag: 0 The output always has its bad flag cleared. If the input piddle does not have its bad flag set, then values are copied with no replacement. copybad Signature: (a(); mask(); [o]b()) Copies values from one piddle to another, setting them bad if they are bad in the supplied mask. Can be done inplace. $a = byte( [0,1,3] ); $mask = byte( [0,0,0] ); set($mask,1,$mask->badvalue); $a->inplace->copybad( $mask ); p $a; [0 BAD 3] It is equivalent to: $c = $a + $mask * 0 Handles bad values. CHANGES
The experimental "BADVAL_PER_PDL" configuration option, which - when set - allows per-piddle bad values, was added after the 2.4.2 release of PDL. The "" variable can be inspected to see if this feature is available. CONFIGURATION
The way the PDL handles the various bad value settings depends on your compile-time configuration settings, as held in "perldl.conf". $PDL::Config{WITH_BADVAL} Set this configuration option to a true value if you want bad value support. The default setting is for this to be true. $PDL::Config{BADVAL_USENAN} Set this configuration option to a true value if you want floating-pont numbers to use NaN to represent the bad value. If set to false, you can use any number to represent a bad value, which is generally more flexible. In the default configuration, this is set to a false value. $PDL::Config{BADVAL_PER_PDL} Set this configuration option to a true value if you want each of your piddles to keep track of their own bad values. This means that for one piddle you can set the bad value to zero, while in another piddle you can set the bad value to NaN (or any other useful number). This is usually set to false. AUTHOR
Doug Burke (djburke@cpan.org), 2000, 2001, 2003, 2006. The per-piddle bad value support is by Heiko Klein(2006). CPAN documentation fixes by David Mertens(2010). All rights reserved. There is no warranty. You are allowed to redistribute this software / documentation under certain conditions. For details, see the file COPYING in the PDL distribution. If this file is separated from the PDL distribution, the copyright notice should be included in the file. perl v5.14.2 2012-05-30 Bad(3pm)
All times are GMT -4. The time now is 02:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy