Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk remove first duplicates
Top Forums Shell Programming and Scripting awk remove first duplicates Post 302885760 by sybadm on Tuesday 28th of January 2014 09:28:34 AM
Old 01-28-2014
Quote:
Originally Posted by pamu
Code:
awk 'NR==FNR{A[$3]++;next}{if(A[$3] > 1 && !B[$3]){B[$3]++;next} }1' file file
 
12  NIL ABD LON
12  NIL ABC AMR
13  NIL ABC AMR
11  NIL ABK AMR


Works really well. bit slow.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to remove duplicates without sorting

Hello, I can remove duplicate entries in a file by: sort File1 | uniq > File2 but how can I remove duplicates without sorting the file? I tried cat File1 | uniq > File2 but it doesn't work thanks (4 Replies)
Discussion started by: orahi001
4 Replies

2. Shell Programming and Scripting

Remove duplicates

Hello Experts, I have two files named old and new. Below are my example files. I need to compare and print the records that only exist in my new file. I tried the below awk script, this script works perfectly well if the records have exact match, the issue I have is my old file has got extra... (4 Replies)
Discussion started by: forumthreads
4 Replies

3. Shell Programming and Scripting

remove duplicates and sort

Hi, I'm using the below command to sort and remove duplicates in a file. But, i need to make this applied to the same file instead of directing it to another. Thanks (6 Replies)
Discussion started by: dvah
6 Replies

4. Shell Programming and Scripting

bash - remove duplicates

I need to use a bash script to remove duplicate files from a download list, but I cannot use uniq because the urls are different. I need to go from this: http://***/fae78fe/file1.wmv http://***/39du7si/file1.wmv http://***/d8el2hd/file2.wmv http://***/h893js3/file2.wmv to this: ... (2 Replies)
Discussion started by: locoroco
2 Replies

5. Shell Programming and Scripting

Awk: Remove Duplicates

I have the following code for removing duplicate records based on fields in inputfile file & moves the duplicate records in duplicates file(1st Awk) & in 2nd awk i fetch the non duplicate entries in inputfile to tmp file and use move to update the original file. Requirement: Can both the awk... (4 Replies)
Discussion started by: siramitsharma
4 Replies

6. Shell Programming and Scripting

Remove duplicates

I have a file with the following format: fields seperated by "|" title1|something class|long...content1|keys title2|somhing class|log...content1|kes title1|sothing class|lon...content1|kes title3|shing cls|log...content1|ks I want to remove all duplicates with the same "title field"(the... (3 Replies)
Discussion started by: dtdt
3 Replies

7. Shell Programming and Scripting

Remove top 3 duplicates

hello , I have a requirement with input in below format abc 123 xyz bcd 365 kii abc 987 876 cdf 987 uii abc 456 yuu bcd 654 rrr Expecting Output abc 456 yuu bcd 654 rrr cdf 987 uii (1 Reply)
Discussion started by: Tomlight
1 Replies

8. Shell Programming and Scripting

Sort and Remove duplicates

Here is my task : I need to sort two input files and remove duplicates in the output files : Sort by 13 characters from 97 Ascending Sort by 1 characters from 96 Ascending If duplicates are found retain the first value in the file the input files are variable length, convert... (4 Replies)
Discussion started by: ysvsr1
4 Replies

9. Shell Programming and Scripting

Remove duplicates

Hi I have a below file structure. 200,1245,E1,1,E1,,7611068,KWH,30, ,,,,,,,, 200,1245,E1,1,E1,,7611070,KWH,30, ,,,,,,,, 300,20140223,0.001,0.001,0.001,0.001,0.001 300,20140224,0.001,0.001,0.001,0.001,0.001 300,20140225,0.001,0.001,0.001,0.001,0.001 300,20140226,0.001,0.001,0.001,0.001,0.001... (1 Reply)
Discussion started by: tejashavele
1 Replies

10. Shell Programming and Scripting

awk - Remove duplicates during array build

Greetings Experts, Issue: Within awk script, remove the duplicate occurrences that are space (1 single space character) separated Description: I am processing 2 files using awk and during processing, I am building an array and there are duplicates on this; how can I delete the duplicates... (3 Replies)
Discussion started by: chill3chee
3 Replies

LEARN ABOUT BSD

il

IL(4)							     Kernel Interfaces Manual							     IL(4)

NAME

       il - Interlan NI1010 10 Mb/s Ethernet interface

SYNOPSIS

       /sys/conf/SYSTEM:
	    NIL  il_controllers # Interlan Ethernet

DESCRIPTION

       The il interface provides access to a 10 Mb/s Ethernet network through an Interlan 1010 or 1010A controller.

       Each  of the host's network addresses is specified at boot time with an SIOCSIFADDR ioctl.  The il interface employs the address resolution
       protocol described in arp(4P) to dynamically map between Internet and Ethernet addresses on the local network.

       The interface normally tries to use a ``trailer'' encapsulation to minimize copying data on input and output.  The use of trailers is nego-
       tiated  with  ARP.   This  negotiation  may  be disabled, on a per-interface basis, by setting the IFF_NOTRAILERS flag with an SIOCSIFFLAGS
       ioctl.

DIAGNOSTICS

       il%d: input error.  The hardware indicated an error in reading a packet off the cable or an illegally sized packet.

       il%d: can't handle af%d.  The interface was handed a message with addresses formatted in an  unsuitable	address  family;  the  packet  was
       dropped.

       il%d: setaddr didn't work.  The interface was unable to reprogram its physical ethernet address.  This may happen with very early models of
       the interface.  This facility is used only when the controller is not the first network interface configured for XNS.  The oldest interface
       tested (2.7.1.0.1.45) has never failed in this way.

       The  following  messages  indicate a probable hardware error performing the indicated operation during autoconfiguration or initialization.
       The status field in the control and status register (the low-order four bits) should indicate the nature of the failure.  See the  hardware
       manual for details.

       il%d: reset failed, csr=%b.

       il%d: status failed, csr=%b.

       il%d: hardware diag failed, csr=%b.

       il%d: verifying setaddr, csr=%b.

       il%d: stray xmit interrupt, csr=%b.

       il%d: can't initialize.

SEE ALSO

       intro(4N), inet(4F), arp(4P)

3rd Berkeley Distribution					  August 20, 1987							     IL(4)
All times are GMT -4. The time now is 11:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy