Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove lines containing 2 or more duplicate strings

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove lines containing 2 or more duplicate strings
# 8  
Old 01-18-2016
I like that approach. Somewhat abbreviated:
Code:
awk '{delete A; for(i=1; i<=NF; i++) if (++A[tolower($i)] > 1) next} 1' file
One and a Two
Unix.com is the Best

This User Gave Thanks to RudiC For This Post:
martinsmith
# 9  
Old 01-18-2016
Note:
  • delete A is BSD awk and GNU awk only. With regular awks use for(i in A) delete A[i] or split("",A)
  • length(A) is GNU sed only, with regular awk, use a counter..

--
So POSIX awk complaint versions of the last three suggestions:
Code:
awk '{for(i=1; i<=NF; i++) A[tolower($i)]; c=0; for(i in A) {delete A[i]; c++}} NF==c' file

and
Code:
awk '{split(x,A); for(i=1; i<=NF; i++) if (A[tolower($i)]++) next} 1' file

--
To also consider minimum string length:
Code:
awk '{split(x,A); for(i=1; i<=NF; i++) if (length($i)>2 && A[tolower($i)]++) next} 1'  file

--
@ravinder: nice approach
Last edited by Scrutinizer; 01-18-2016 at 01:46 PM.. Reason: Added possibility of split() function to delete entire array, Thanks MadeINGermany
This User Gave Thanks to Scrutinizer For This Post:
martinsmith
# 10  
Old 01-18-2016
Quote:
Originally Posted by Scrutinizer
Note:
  • delete A is BSD awk and GNU awk only. With regular awks use for(i in A) delete A[i]
The usual trick to delete an array is
Code:
split("",A)

This User Gave Thanks to MadeInGermany For This Post:
Scrutinizer
# 11  
Old 01-18-2016
Thanks MadeInGermany, forgot about that one, added to my post...
Last edited by Scrutinizer; 01-18-2016 at 01:46 PM..
# 12  
Old 01-18-2016
Best of breed
Code:
awk '{split("",A); for(i=1; i<=NF; i++) if (A[tolower($i)]++) next} 1' file

(Just seeing Scrutinizer has it already)
Last edited by MadeInGermany; 01-18-2016 at 04:25 PM..
This User Gave Thanks to MadeInGermany For This Post:
martinsmith
# 13  
Old 01-18-2016
Code:
cat martinsmith.file

Code:
One and a Two
Unix.com is the Best
This as a Line Line
Example will be the same that EXAMPLE
Example duplicate sentence with the word duplicate

Code:
perl -ne 'print unless /(\b\w+\b).*\g1/i' martinsmith.file

Code:
One and a Two
Unix.com is the Best

This User Gave Thanks to Aia For This Post:
martinsmith
# 14  
Old 01-19-2016
Aia, your solution does not work. First, there is a g too many. Second, the \b is not replicated to the \1. But even if I improve it like
Code:
perl -ne 'print unless /\b(\w+)\b.*\b\1\b/i' martinsmith.file

it won't print the following line
Code:
Unix.unix should be printed

This User Gave Thanks to MadeInGermany For This Post:
martinsmith
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. Shell Programming and Scripting

Remove duplicate lines from a file

Hi, I have a csv file which contains some millions of lines in it. The first line(Header) repeats at every 50000th line. I want to remove all the duplicate headers from the second occurance(should not remove the first line). I don't want to use any pattern from the Header as I have some... (7 Replies)
Discussion started by: sudhakar T
7 Replies

3. Shell Programming and Scripting

Getting lines between two strings with duplicate set of data

if I have the following lines in a file app.log some lines here <AAAA> abc <id>123456789</id> ddd </AAAA>some lines here too <BBBB> abc <id>123456789</id> ddd </BBBB>some lines here too <AAAA> xyz <id>987654321</id> ssss </AAAA>some lines here again... How do I get the... (5 Replies)
Discussion started by: nariwithu
5 Replies

4. 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

5. Shell Programming and Scripting

remove duplicate lines with condition

hi to all Does anyone know if there's a way to remove duplicate lines which we consider the same only if they have the first and the second column the same? For example I have : us2333 bbb 5 us2333 bbb 3 us2333 bbb 2 and I want to get us2333 bbb 10 The thing is I cannot... (2 Replies)
Discussion started by: vlm
2 Replies

6. Shell Programming and Scripting

Need to remove the duplicate lines from a log!!

Hello Folks, Can some one help me with the removal of duplicate lines from a log file and send it to another log file. It's bit complicated as two lines are same but only difference is the timestamp, but some lines are uniq. Line has been seperated by colon's. Log file:... (5 Replies)
Discussion started by: sim_je
5 Replies

7. Shell Programming and Scripting

Delete lines in file containing duplicate strings, keeping longer strings

The question is not as simple as the title... I have a file, it looks like this <string name="string1">RZ-LED</string> <string name="string2">2.0</string> <string name="string2">Version 2.0</string> <string name="string3">BP</string> I would like to check for duplicate entries of... (11 Replies)
Discussion started by: raidzero
11 Replies

8. 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

9. UNIX for Dummies Questions & Answers

Delete lines with duplicate strings based on date

Hey all, a relative bash/script newbie trying solve a problem. I've got a text file with lots of lines that I've been able to clean up and format with awk/sed/cut, but now I'd like to remove the lines with duplicate usernames based on time stamp. Here's what the data looks like 2007-11-03... (3 Replies)
Discussion started by: mattv
3 Replies

10. 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
Login or Register to Ask a Question