Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

perl/shell need help to remove duplicate lines from files

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting perl/shell need help to remove duplicate lines from files
# 1  
Old 12-22-2010
perl/shell need help to remove duplicate lines from files
Dear All,


I have multiple files having number of records, consist of more than 10 columns some column values are duplicate and i want to remove these duplicate values from these files.
Duplicate values may come in different files.... all files laying in single directory..

Need help to remove line contain duplicate values, and store in another files with same file name having .dup extention...

Sample files
Input_file_001.txt
Code:
AAAAAC01            0397fa           AB2010120211200500000000200009904136515                 099999999999                 IUVSN11                                 MOB
          AAAAAA01  03981d           AB2010120211130100000007430009588004780                 888888888888888                                 GGGCZ11                     MOB                                              76457499048         3122
          BBBBBBB01  03982f           AB2010120211203400000000150009588000696                 909090909090909                                 KKKKKG11                     MOB                                              64325984725         4107
AAAAAC01            0396fa           AB2010120211200500000000200009904136515                 099999999999                 IUVSN11                                 MOB ------ contain duplicate value
          AAAAAA01  03901d           AB2010120211130100000007430009588004780                 888888888888888                                 GGGCZ11                     MOB                                              76457499048         3122 ------ contain duplicate value


Input_file_002.txt
Code:
CCCCCCA01  03981d           AB2010120211130100000007430009588004780                 11111111111118                                 GGGCZ11                     MOB                                              76457499048         3122
          BBBBBBB01  03932f           AB2010120211203400000000150009588000696                 909090909090909                                 KKKKKG11                     MOB                                              64325984725         4107 – contain duplicate values of first file

Need out put something like this
Input_file_001.txt
Code:
AAAAAC01            0397fa           AB2010120211200500000000200009904136515                 099999999999                 IUVSN11                                 MOB
          AAAAAA01  03981d           AB2010120211130100000007430009588004780                 888888888888888                                 GGGCZ11                     MOB                                              76457499048         3122
          BBBBBBB01  03982f           AB2010120211203400000000150009588000696                 909090909090909                                 KKKKKG11                     MOB                                              64325984725         4107

Input_file_001.txt.dup
Code:
AAAAAC01            0396fa           AB2010120211200500000000200009904136515                 099999999999                 IUVSN11                                 MOB 
          AAAAAA01  03901d           AB2010120211130100000007430009588004780                 888888888888888                                 GGGCZ11                     MOB                                              76457499048         3122


Input_file_002.txt
Code:
CCCCCCA01  03981d           AB2010120211130100000007430009588004780                 11111111111118                                 GGGCZ11                     MOB                                              76457499048         3122

Input_file_002.txt.dup
Code:
BBBBBBB01  03932f           AB2010120211203400000000150009588000696                 909090909090909                                 KKKKKG11                     MOB                                              64325984725         4107




Currently i’m using following command to remove duplicate.... but not able to store duplicate lines .dup file
Code:
awk '!x [substr($0,38,93), substr($0,94,141)]++'   * > all_files_

Last edited by radoulov; 12-22-2010 at 10:42 AM.. Reason: code tags (well trying...)
# 2  
Old 12-22-2010
If we are talking utterly duplicate lines, it can get VM intensive to do it all in memory so you can preserve order. Are duplicate lines always in the same file? Here is a robust dup finder using sort:
Code:
for file in *.txt
do
  sort $file|uniq -d >>$file.dups
  if [ ! -s $file.dups ]
  then
    rm -f $file.dups
  fi
done

You only get one copy of each dup.
# 3  
Old 12-24-2010
duplicate lines may contain in different files... Smilie

duplicate need to identify if substr($0,38,93), substr($0,94,141) values are duplicate

thank you
# 4  
Old 12-24-2010
OK, A. the key is not the whole line, and B. duplicates across files are bad, two complications. Reporting the duplicate means a definition of the original, expecially for non-key data.
  • If the lines have identical keys and not identical payload (fields not keys), then will file name order and order in file pick a winner?
  • We need to survey all files for duplicate keys, then extract the unique and winners to load, and the losers to report. Think of them as two important products, not picking favorites. While most days there may be no duplicates, if one day there are tons, you still want it to blast through.
  • There are two approaches to dealing with duplicate filtering. You can save every key in an associative array (magic box that recalls by value, but may not be robust in speed and stability with huge volume) or you can sort in key, priority order (more traditional and quite robust if you have the disk space. Store just the last key, process the first of every key and log the others. Worked great on tape in 1960 with 16K or RAM! :-)
  • Tagging the duplicates by original file means adding the file name to every record, possible but a bit of a luxury if not needed.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to remove duplicate lines?

Hi All, I am storing the result in the variable result_text using the below code. result_text=$(printf "$result_text\t\n$name") The result_text is having the below text. Which is having duplicate lines. file and time for the interval 03:30 - 03:45 file and time for the interval 03:30 - 03:45 ... (4 Replies)
Discussion started by: nalu
4 Replies

2. Windows & DOS: Issues & Discussions

Remove duplicate lines from text files.

So, I have text files, one "fail.txt" And one "color.txt" I now want to use a command line (DOS) to remove ANY line that is PRESENT IN BOTH from each text file. Afterwards there shall be no duplicate lines. (1 Reply)
Discussion started by: pasc
1 Replies

3. UNIX for Dummies Questions & Answers

Remove Duplicate Lines

Hi I need this output. Thanks. Input: TAZ YET FOO FOO VAK TAZ BAR Output: YET VAK BAR (10 Replies)
Discussion started by: tara123
10 Replies

4. Shell Programming and Scripting

[uniq + awk?] How to remove duplicate blocks of lines in files?

Hello again, I am wanting to remove all duplicate blocks of XML code in a file. This is an example: input: <string-array name="threeItems"> <item>item1</item> <item>item2</item> <item>item3</item> </string-array> <string-array name="twoItems"> <item>item1</item> <item>item2</item>... (19 Replies)
Discussion started by: raidzero
19 Replies

5. Shell Programming and Scripting

Remove duplicate lines

Hi, I have a huge file which is about 50GB. There are many lines. The file format likes 21 rs885550 0 9887804 C C T C C C C C C C 21 rs210498 0 9928860 0 0 C C 0 0 0 0 0 0 21 rs303304 0 9941889 A A A A A A A A A A 22 rs303304 0 9941890 0 A A A A A A A A A The question is that there are a few... (4 Replies)
Discussion started by: zhshqzyc
4 Replies

6. Shell Programming and Scripting

remove duplicate lines using awk

Hi, I came to know that using awk '!x++' removes the duplicate lines. Can anyone please explain the above syntax. I want to understand how the above awk syntax removes the duplicates. Thanks in advance, sudvishw :confused: (7 Replies)
Discussion started by: sudvishw
7 Replies

7. Shell Programming and Scripting

Command to remove duplicate lines with perl,sed,awk

Input: hello hello hello hello monkey donkey hello hello drink dance drink Output should be: hello hello monkey donkey drink dance (9 Replies)
Discussion started by: cola
9 Replies

8. Shell Programming and Scripting

remove all duplicate lines from all files in one folder

Hi, is it possible to remove all duplicate lines from all txt files in a specific folder? This is too hard for me maybe someone could help. lets say we have an amount of textfiles 1 or 2 or 3 or... maximum 50 each textfile has lines with text. I want all lines of all textfiles... (8 Replies)
Discussion started by: lowmaster
8 Replies

9. Shell Programming and Scripting

how to remove duplicate lines

I have following file content (3 fields each line): 23 888 10.0.0.1 dfh 787 10.0.0.2 dssf dgfas 10.0.0.3 dsgas dg 10.0.0.4 df dasa 10.0.0.5 df dag 10.0.0.5 dfd dfdas 10.0.0.5 dfd dfd 10.0.0.6 daf nfd 10.0.0.6 ... as can be seen, that the third field is ip address and sorted. but... (3 Replies)
Discussion started by: fredao
3 Replies

10. Shell Programming and Scripting

Remove Duplicate Lines in File

I am doing KSH script to remove duplicate lines in a file. Let say the file has format below. FileA 1253-6856 3101-4011 1827-1356 1822-1157 1822-1157 1000-1410 1000-1410 1822-1231 1822-1231 3101-4011 1822-1157 1822-1231 and I want to simply it with no duplicate line as file... (5 Replies)
Discussion started by: Teh Tiack Ein
5 Replies
Login or Register to Ask a Question