How to remove duplicate lines?

Login or Register to Ask a Question and Join Our Community

How to remove duplicate lines?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to remove duplicate lines?

05-24-2017

Registered User

25, 0

Join Date: Apr 2017

Last Activity: 5 June 2017, 7:28 AM EDT

Posts: 25

Thanks Given: 1

Thanked 0 Times in 0 Posts

How to remove duplicate lines?

Hi All,
I am storing the result in the variable result_text using the below code.

Code:

result_text=$(printf "$result_text\t\n$name")

The result_text is having the below text. Which is having duplicate lines.

Code:

file and time for the interval 03:30 - 03:45 
file and time for the interval 03:30 - 03:45 
file and time for the interval 03:45 - 03:59 
file and time for the interval 04:00 - 04:15 
file and time for the interval 04:00 - 04:15 
file and time for the interval 04:15 - 04:30 
file and time for the interval 04:15 - 04:30

I have tried the below code to remove duplicates but not working.

Code:

result_text=$(printf "$result_text" | sort | uniq)

Please help me to remove duplicate lines.
Thanks in advance.

Moderator's Comments:

Mod Comment

Posting "Does not work" without explanation does not help you or anyone. If a command does not work for you, please show the exact circumstances you used it, and the exact error or malfunction you received. Do not paraphrase errors, or post the text as links, images, or attachments if you can avoid it: Paste the exact message, in code tags, like [code] text [/code] or by selecting the text and using the

button.

Thank you.

The UNIX and Linux Forums

Last edited by RudiC; 05-24-2017 at 09:59 AM..

nalu

View Public Profile for nalu

Find all posts by nalu

05-24-2017

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Works for me, given you correct the variable assignment to include the last trailing space, and the text remains sorted as it is right now:

Code:

printf "$result_text" | uniq
file and time for the interval 03:30 - 03:45 
file and time for the interval 03:45 - 03:59 
file and time for the interval 04:00 - 04:15 
file and time for the interval 04:15 - 04:30

RudiC

View Public Profile for RudiC

Find all posts by RudiC

05-24-2017

Moderator

3,105, 1,603

Join Date: May 2013

Last Activity: 31 August 2020, 1:46 AM EDT

Location: Chennai

Posts: 3,105

Thanks Given: 1,269

Thanked 1,603 Times in 1,369 Posts

Hello nalu,

Your Input_file is having spaces at last of lines. Could you please try following and let me know if this helps you.

Code:

awk '{sub(/[[:space:]]+$/,"");} !A[$0]++'   Input_file
OR
echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++'

Thanks,
R. Singh

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

05-24-2017

Registered User

25, 0

Join Date: Apr 2017

Last Activity: 5 June 2017, 7:28 AM EDT

Posts: 25

Thanks Given: 1

Thanked 0 Times in 0 Posts

Hi Ravinder,

Thanks for your prompt response.

This code is removing duplicate lines.

Code:

echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++'

If I assign the result to a variable it's not working.

Code:

result_text1=$(echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++')

echo $result_text1

Please help me.

Thanks in advance.

nalu

View Public Profile for nalu

Find all posts by nalu

05-24-2017

Moderator

3,105, 1,603

Join Date: May 2013

Last Activity: 31 August 2020, 1:46 AM EDT

Location: Chennai

Posts: 3,105

Thanks Given: 1,269

Thanked 1,603 Times in 1,369 Posts

Quote:

Originally Posted by nalu

Hi Ravinder,
Thanks for your prompt response.
This code is removing duplicate lines.

Code:

echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++'

If I assign the result to a variable it's not working.

Code:

result_text1=$(echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++')
echo $result_text1

Please help me.
Thanks in advance.

Hello nalu,

You could hit THANKS button for saying thanks to anyone here.
Try following and let me know if this helps you. I am getting proper output from this command.

Code:

result_text1=$(echo "$result_text" | awk '{sub(/[[:space:]]+$/,"");} !A[$0]++')
echo "$result_text1"

Thanks,
R. Singh

Last edited by RavinderSingh13; 05-24-2017 at 10:51 AM..

This User Gave Thanks to RavinderSingh13 For This Post:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove lines containing 2 or more duplicate strings

Within my text file i have several thousand lines of text with some lines containing duplicate strings/words. I would like to entirely remove those lines which contain the duplicate strings. Eg; One and a Two Unix.com is the Best This as a Line Line Example duplicate sentence with the word...

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

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

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

5. 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:...

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

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

8. UNIX for Dummies Questions & Answers

Remove Duplicate lines from File

I have a log file "logreport" that contains several lines as seen below: 04:20:00 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but responded to ping 06:38:08 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but responded to ping 07:11:05 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but...

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

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

Login or Register to Ask a Question