Need to print duplicate row along with highest version of original

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print whole line with highest value from one column

Hi, I have a little issue right now. I have a file with 4 columns test0000002,10030010330,c_,218 test0000002,10030010330,d_,202 test0000002,10030010330,b_,193 test0000002,10030010020,c_,178 test0000002,10030010020,b_,170 test0000002,10030010330,a_,166 test0000002,10030010020,a_,151...

2. Shell Programming and Scripting

Need to show highest version line from the list

Hi All, Need help here, can you tell me the syntax to line grep the highest file version? 0 04-05-2016 08:00 lib/SBSSchemaProject.jar/schemas/ 0 04-05-2016 08:00 lib/SBSSchemaProject.jar/schemas/airprice/ 0 04-05-2016 08:00 ...

3. Shell Programming and Scripting

Filtering out duplicates with the highest version number

Hi, I have a huge text file with filenames which which looks like the following ie uniquenumber_version_filename: e.g. 1234_1_xxxx 1234_2_vfvfdbb 343333_1_vfvfdvd 2222222_1_ggggg 55555_1_xxxxxx 55555_2_vrbgbgg 55555_3_grgrbr What I need to do is examine the file, look for...

4. Shell Programming and Scripting

Remove duplicates and update last 2 digits of the original row with 0's

Hi, I have a requirement where I have to remove duplicates from a file based on the first 8 chars (It is fixed width file of 10 chars length) and whenever a duplicate row is found, its original row's last 2 chars should be updated to all 0's. I thought of using sort -u -k 1.1,1.8...

5. Shell Programming and Scripting

Print the key with highest value

print the key with highest value input a 10 a 20 a 30 b 2 b 3 b 1 output a 30 b 3

6. UNIX for Dummies Questions & Answers

Print line with highest value from one column

Hi everyone, This is my first post, but I have already received a lot of help from the forums in the past. Thanks! I've searched the forums and my question is very similar to an earlier post entitled "Printing highest value from one column", which I am apparently not yet allowed to post a...

7. Shell Programming and Scripting

How to delete a duplicate line and original with sed.

I am completely new to shell scripting but have been assigned the task of creating several batch files to manipulate data. My final task requires me to find lines that have duplicates present then delete not only the duplicate but the original as well. The script will be used in a windows...

8. UNIX for Advanced & Expert Users

tar: how to preserve atime? (also on extracted version, not just original)

How do I make tar set the correct atime on the extracted version? The option --atime-preserve works just on the original, not on the extracted file. The extracted files always have current time as atime, which is bad.

9. UNIX for Dummies Questions & Answers

about UNIX? original version?

sorry for my English We'll report about Unix in my school, for Operating Systems subject... with Installation demo.... I'm wondering if System V, which is from original developers AT&T still exist and downloadable? because I cant find it anywhere... then i found out that Solaris, MacOS...

10. Linux Benchmarks

Original BYTE UNIX Benchmarks (Version 3.11)

Just dusted off an old version of the Byte UNIX Benchmarks from our old benchmark days at http://linux.silkroad.com/ and ran them against www.unix.com: ============================================================== BYTE UNIX Benchmarks (Version 3.11) System -- Linux www 2.4.20 #2 Mon...

LEARN ABOUT PHP

db2_result

DB2_RESULT(3)								 1							     DB2_RESULT(3)

db2_result - Returns a single column from a row in the result set

SYNOPSIS

       mixed db2_result (resource  $stmt, mixed  $column)

DESCRIPTION

	Use  db2_result(3)  to	return	the  value of a specified column in the current row of a result set. You must call db2_fetch_row(3) before
       calling db2_result(3) to set the location of the result set pointer.

PARAMETERS

	      o $stmt
		- A valid stmt resource.

	      o $column
		- Either an integer mapping to the 0-indexed field in the result set, or a string matching the name of the column.

RETURN VALUES

	Returns the value of the requested field if the field exists in the result set. Returns NULL if the field does not  exist,  and  issues  a
       warning.

EXAMPLES

       Example #1

	      A db2_result(3) example

	       The  following  example demonstrates how to iterate through a result set with db2_fetch_row(3) and retrieve columns from the result
	      set with db2_result(3).

	      <?php
	      $sql = 'SELECT name, breed FROM animals WHERE weight < ?';
	      $stmt = db2_prepare($conn, $sql);
	      db2_execute($stmt, array(10));
	      while (db2_fetch_row($stmt)) {
		  $name = db2_result($stmt, 0);
		  $breed = db2_result($stmt, 'BREED');
		  print "$name $breed";
	      }
	      ?>

	      The above example will output:

	      cat Pook
	      gold fish Bubbles
	      budgerigar Gizmo
	      goat Rickety Ride

SEE ALSO

       db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_fetch_row(3).

PHP Documentation Group 													     DB2_RESULT(3)

Shell Programming and Scripting