Remove duplicates from end of file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove duplicates from end of file
# 1  
Old 11-13-2009
Remove duplicates from end of file

1/p
----
A
B
C
A
C
o/p
---
B
A
C
From input file it should remove duplicates from end without changing order
# 2  
Old 11-13-2009
In should be handy to use tac in this case:

Code:
tac file | awk '!a[$0]++' | tac

# 3  
Old 11-13-2009
This perl script should do what you want.

Code:
#!/usr/bin/perl

use strict;

my %seen;     # hash used to determine if a line has been seen.
my @a_line;   # array to store unique lines.
my $line;     # variable to store each line.

#
# Loop through all lines in the file
#
while (<>)
{
   #
   # Ignore the line if it has been seen before.
   #
   unless ($seen{$_})
   {

      #
      # Increment the hash for the line.
      #
      $seen{$_}++;

      #
      # Store the line in the array of lines.
      #
      push( @a_line, $_);
   }
}

# 
# Print out each line in the array of lines.
#
foreach (@a_line)
{
   print "$_";
}

exit
#
# end of dup.pl
#

Sample Input Data

B
A
C
A
C

Output

./dup.pl < dup.dat
B
A
C

Hope this helps.
# 4  
Old 11-13-2009
Code:
tail -r file| awk '!x[$0]++' | tail -r

# 5  
Old 11-13-2009
Code:
#!/bin/bash
gawk  'BEGIN{
    RS="\n$"
    FS="\n"
}
{
 for(o=NF;o>0;o--){
    if (!($o in a) ){
        s[++d]=$o
    }
    a[$o]
 }
}END{
 for(i=d;i>0;i--){
    print s[i]
 }
}' file

output
Code:
# ./shell.sh
B
A
C


Last edited by ghostdog74; 11-13-2009 at 09:37 AM..
# 6  
Old 11-16-2009
Code:
while(<DATA>){
	chomp;
	$hash{$_}=$.
}
print join "\n", sort {$hash{$a}<=>$hash{$b}} keys %hash; 
__DATA__
A
B
C
A
C

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Remove duplicates in flat file

Hi all, I have a issues while loading a flat file to the DB. It is taking much time. When analyzed i found out that there are duplicates entry in the flat file. There are 2 type of Duplicate entry. 1) is entire row is duplicate. ( i can use sort | uniq) to remove the duplicated entry. 2) the... (4 Replies)
Discussion started by: samjoshuab
4 Replies

2. Shell Programming and Scripting

To remove duplicates from pipe delimited file

Hi some one please help me to remove duplicates from a pipe delimited file based on first two columns. 123|asdf|sfsd|qwrer 431|yui|qwer|opws 123|asdf|pol|njio Here My first record and last record are duplicates.As per my requirement I want all the latest records into one file. I want the... (12 Replies)
Discussion started by: ginrkf
12 Replies

3. UNIX for Dummies Questions & Answers

Remove duplicates and keep them in a separate file

Hi, I have a tablular separated file and I want to remove all the rows that have duplicates. The diuplicates I need to check are in column 13. I have tried to use awk but I have no Idea how to keep the duplicate file. awk 'FNR==NR{a++;next}(a> 1)' tomodify.txt tomodify.txt > new.txt ... (4 Replies)
Discussion started by: flacchy
4 Replies

4. UNIX for Dummies Questions & Answers

Remove duplicates from a file

Can u tell me how to remove duplicate records from a file? (11 Replies)
Discussion started by: saga20
11 Replies

5. Shell Programming and Scripting

How to remove duplicates from the .dat file

All, I have a file 1181CUSTOMER-L061411_003500.dat.Z having duplicate records in it. bash-2.05$ zcat 1181CUSTOMER-L061411_003500.dat.Z|grep "90876251S" 90876251S|ABG, AN ADAYANA COMPANY|3550 DEPAUW BLVD|||US|IN|INDIANAPOLIS||DAL|46268||||||GEN|||||||USD|||ABG, AN ADAYANA... (3 Replies)
Discussion started by: Oracle_User
3 Replies

6. Shell Programming and Scripting

Search based on 1,2,4,5 columns and remove duplicates in the same file.

Hi, I am unable to search the duplicates in a file based on the 1st,2nd,4th,5th columns in a file and also remove the duplicates in the same file. Source filename: Filename.csv "1","ccc","information","5000","temp","concept","new" "1","ddd","information","6000","temp","concept","new"... (2 Replies)
Discussion started by: onesuri
2 Replies

7. Shell Programming and Scripting

Remove duplicates from a file

Hi, I need to remove duplicates from a file. The file will be like this 0003 10101 20100120 abcdefghi 0003 10101 20100121 abcdefghi 0003 10101 20100122 abcdefghi 0003 10102 20100120 abcdefghi 0003 10103 20100120 abcdefghi 0003 10103 20100121 abcdefghi Here if the first colum and... (6 Replies)
Discussion started by: gpaulose
6 Replies

8. Shell Programming and Scripting

Shell script to remove duplicates lines in a file

Hi, I am writing a shell script that needs to remove duplicate lines within a file by category. example: section a a c b a section b a b a c I need to remove the duplicates within th category with out removing the duplicates from the 2 different sections (one of the a's in section... (1 Reply)
Discussion started by: RichElks
1 Replies

9. Shell Programming and Scripting

remove duplicates within a block in a file..help required

hi.. i have a file in the following format :- name-a age -12 address-123 age-12 phone-22222 ============ name-ab age -11 address-123 age-11 phone-222223 ============= name-abc age -12 address-1234 age-12 phone-2222223 ============= (2 Replies)
Discussion started by: nipun_garg
2 Replies

10. Shell Programming and Scripting

Remove duplicates from File from specific location

How can i remove the duplicate lines from a file, for example sample123456Sample testing123456testing XXXXX131323XXXXX YYYYY423432YYYYY fsdfdsf123456gsdfdsd all the duplicates from column 6-12 , must be deleted. I want to consider the first row, if same comes in the given range i want to... (1 Reply)
Discussion started by: gopikgunda
1 Replies
Login or Register to Ask a Question