Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Any 'shortcut' to doing this search for duplicate and print max
Top Forums UNIX for Dummies Questions & Answers Any 'shortcut' to doing this search for duplicate and print max Post 302967692 by RudiC on Friday 26th of February 2016 10:59:09 AM
Old 02-26-2016
You know awk works on pattern {action} pairs with the default action being {print}.
!T[$2]++ is a pattern (The logical value of empty or zero strings is FALSE, the logical negation will make it TRUE), which reads
if T[$2] is empty, print, increment T[$2] (so any further references will "fail" = print on first occurrence only).
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to print mon and max values of ranges

HI all I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2 EG 114,7964,1,y,y,n 114,7965,1,y,y,n 114,7966,1,y,y,n 114,7967,1,y,y,n 114,7969,1,y,y,n 114,7970,1,y,y,n 114,7971,1,y,y,n 114,7972,1,y,y,n... (3 Replies)
Discussion started by: Mudshark
3 Replies

2. Shell Programming and Scripting

Search max value in a column in a file instead of sort

Hi Everyone, 1.txt 00:00:00 0 0 0 0 0 0 0 00:00:01 0 0 0 2 1 33 2 00:00:02 5 0 0 0 0 0 0 00:00:03 0 4 0 0 0 0 0... (5 Replies)
Discussion started by: jimmy_y
5 Replies

3. Shell Programming and Scripting

print max number of 2 columns - awk

Is it possible to print max number of 2 columns - awk note: print max if the integer is positive and print min if the integer is negative input a 1 2 b 3 4 c 5 1 d -3 -5 d -5 -3 output a 2 b 4 c 5 d -5 d -5 (4 Replies)
Discussion started by: quincyjones
4 Replies

4. Shell Programming and Scripting

Print min and max value from two column

Dear All, I have data like this, input: 1254 10125 1254 10126 1254 10127 1254 10128 1254 10129 1255 10130 1255 10131 1255 10132 1255 10133 1256 10134 1256 10135 1256 10137... (3 Replies)
Discussion started by: aksin
3 Replies

5. Shell Programming and Scripting

Median and max of duplicate rows

Hi all, plz help me with this, I want to to extract the duplicate rows (column 1) in a file which at least repeat 4 times. then I want to summarize them by getting the max , mean, median and min. The file is sorted by column 1, all the repeated rows appear together. If number of elements is... (5 Replies)
Discussion started by: ritakadm
5 Replies

6. Shell Programming and Scripting

Sum value in a row and print the max

I have the input file in attached. I want the output file : Date , Time , Max_Bearer 11/01/2013 , 23:00 , 1447.894167 11/02/2013 , 00:00 , 1429.266667 11/03/2013 , 00:00 , 712.3175 11/04/2013 , 22:00 , 650.9533333 11/05/2013 , 23:00 , 665.9558333 11/06/2013 , 23:00 , 659.8616667... (2 Replies)
Discussion started by: justbow
2 Replies

7. Shell Programming and Scripting

Search pattern on logfile and search for day/dates and skip duplicate lines if any

Hi, I've written a script to search for an Oracle ORA- error on a log file, print that line and the .trc file associated with it as well as the dateline of when I assumed the error occured. In most it is the first dateline previous to the error. Unfortunately, this is not a fool proof script.... (2 Replies)
Discussion started by: newbie_01
2 Replies

8. Shell Programming and Scripting

Print root number between min and max ranges

Hi to all, Please help on the following problem, I'm not where to begin, if awk or shell script. I have pairs of ranges of numbers and I need to find the root or roots of ranges based on min Range and Max ranges Example #1: If min range is 120000 and max ranges 124999, it means that are... (5 Replies)
Discussion started by: Ophiuchus
5 Replies

9. Shell Programming and Scripting

Find Max value of line and print

I need to find the max value of all columns except the 1st column and print the answer along with the 1st column. Input 123xyz 0 0 1 2 0 0 0 0 0 0 0 234xyz 0 0 0 0 0 0 0 0 0 0 0 345xyz 0 0 1 0 0 0 ... (8 Replies)
Discussion started by: ncwxpanther
8 Replies

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies

LEARN ABOUT DEBIAN

btarcmp

BTARCMP(1)						      General Commands Manual							BTARCMP(1)

NAME

       btarcmp - a diff for Barry tar backup files

SYNOPSIS

       btarcmp [-b][-d db][-D db][-h][-I charset][-P][-S][-v] tar0 tar1

DESCRIPTION

       btarcmp	takes  two  Barry  backup  tar	files  on the command line, and displays the differences it finds between them.  If records can be
       parsed, individual field differences are also displayed.  Added and removed records are noted.  Differences in  database  availability  are
       noted as well.  If unable to parse the records, hex dumps are used.

OPTIONS

       -b     Use brief filename markers.  Useful when tar filenames are extremely long.

       -d db  Name  of	database  to compare.  Can be used multiple times to compare multiple databases.  If not specified, all databases are com-
	      pared.

       -D db  Name of database to skip.  Can be used multiple times.  Overrides all other database selection options.

       -h     Show summary of options.

       -I charset
	      Specifies the iconv charset to use for converting international strings.	The Blackberry uses the  WINDOWS-1252  charset,  which	is
	      incompatible with the more common code pages used in Linux.  The most useful charset to use with this option is UTF-8, and is highly
	      recommended.  Any other charset available via 'iconv --list' can be used here too, but may not be successful for some character con-
	      versions.

       -S     Displays list of known database records, which can be parsed.

       -v     Verbose output, which includes record data of added and deleted records in the output.  If used twice, hex data is printed as well.

AUTHOR

       btarcmp is part of the Barry project.

SEE ALSO

       http://www.netdirect.ca/barry

								 January 20, 2010							BTARCMP(1)
All times are GMT -4. The time now is 05:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy