Visit Our UNIX and Linux User Community


Remove duplicate


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Remove duplicate
# 1  
Old 08-07-2013
Remove duplicate

Hi,

How can I replace || with space and then remove duplicate from following text?

Code:
T111||T222||T444||T222||T555

Thanks in advance

Last edited by Scott; 08-07-2013 at 11:02 AM.. Reason: Code tags
# 2  
Old 08-07-2013
what have you tried?
# 3  
Old 08-07-2013
Quote:
Originally Posted by tinku981
Hi,

How can I replace || with space and then remove duplicate from following text?

T111||T222||T444||T222||T555

Thanks in advance
save the text in a file e.g. 'file.txt':
input: file.txt
Code:
T111||T222||T444||T222||T555

command:
Code:
cat file.txt |tr -s '||' '\n'|sort|uniq -u|tr -s '\n' ' '

output:
Code:
T111 T444 T555

# 4  
Old 08-07-2013
What duplicate you want to delete
please show how your output shall looks like
# 5  
Old 08-07-2013
tinku981,
check this out:

Code:
$ awk -F"[|][|]" '{for(i=1;i<=NF;i++) print $i }' file|sort|uniq -c
   1 T111
   2 T222
   1 T444
   1 T555

# 6  
Old 08-08-2013
Hello tinku981,

Could you please try following. Lets say file remove_desired_char have the all information.


Code:
cat remove_duplicate_char | tr "||" "\n" | awk '!a[$NF]++' | tr "\n" " "

Output will be as follows.

Code:
T111  T222 T444 T555



Thanks,
R. Singh
# 7  
Old 08-08-2013
There's most likely a faster way, but this should do the trick:
echo "T111||T222||T444||T222||T555" |sed 's/||/\n/g' |sort -u |awk '{ printf "%s ", $0 }'
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #604
Difficulty: Medium
In MySQL 8.0 table encryption can be managed globally by defining and enforcing encryption defaults
True or False?

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

3. Shell Programming and Scripting

Remove duplicate

Hi , I have a pipe seperated file repo.psv where i need to remove duplicates based on the 1st column only. Can anyone help with a Unix script ? Input: 15277105||Common Stick|ESHR||Common Stock|CYRO AB 15277105||Common Stick|ESHR||Common Stock|CYRO AB 16111278||Common Stick|ESHR||Common... (12 Replies)
Discussion started by: samrat dutta
12 Replies

4. Shell Programming and Scripting

How to remove duplicate ID's?

HI I have file contains 1000'f of duplicate id's with (upper and lower first character) as below i/p: a411532A411532a508661A508661c411532C411532 Requirement: But i need to ignore lowercase id's and need only below id's o/p: A411532 A508661 C411532 (9 Replies)
Discussion started by: buzzme
9 Replies

5. Shell Programming and Scripting

Help with remove duplicate content

Input file data_1 10 US data_1 2 US data_1 5 UK data_2 20 ENGLAND data_2 12 KOREA data_3 4 CHINA . . data_60 123 US data_60 23 UK data_60 45 US Desired output file data_1 10 US data_1 5 UK data_2 20 ENGLAND data_2 12 KOREA (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. Shell Programming and Scripting

remove duplicate

Hi, I am tryung to use shell or perl to remove duplicate characters for example , if I have " I love google" it will become I love ggle" or even "I loveggle" if removing duplicate white space Thanks CC (6 Replies)
Discussion started by: ccp
6 Replies

7. UNIX for Dummies Questions & Answers

Remove duplicate in array

Hi, I have a list of numbers stored in an array as below. 5 7 10 30 30 40 50 Please advise how could I remove the duplicate value in the array ? Thanks in advance. (5 Replies)
Discussion started by: Rock
5 Replies

8. Shell Programming and Scripting

Remove duplicate

Hi all, I have a text file fileA.txt DXRV|02/28/2006 11:36:49.049|SAC||||CDxAcct=2420991350 DXRV|02/28/2006 11:37:06.404|SAC||||CDxAcct=6070970034 DXRV|02/28/2006 11:37:25.740|SAC||||CDxAcct=2420991350 DXRV|02/28/2006 11:38:32.633|SAC||||CDxAcct=6070970034 DXRV|02/28/2006... (2 Replies)
Discussion started by: sabercats
2 Replies

9. Shell Programming and Scripting

Remove duplicate ???

Hi all, I have a out.log file CARR|02/26/2006 10:58:30.107|CDxAcct=1405157051 CARR|02/26/2006 11:11:30.107|CDxAcct=1405157051 CARR|02/26/2006 11:18:30.107|CDxAcct=7659579782 CARR|02/26/2006 11:28:30.107|CDxAcct=9534922327 CARR|02/26/2006 11:38:30.107|CDxAcct=9534922327 CARR|02/26/2006... (3 Replies)
Discussion started by: sabercats
3 Replies

10. Shell Programming and Scripting

remove duplicate

i have a text its contain many record, but its written in one line, i want to remove from that line the duplicate record, not record have fixed width ex: width = 4 inputfile test.txt =abc cdf abc abc cdf fgh fgh abc abc i want the outputfile =abc cdf fgh only those records can any one help... (4 Replies)
Discussion started by: kazanoova2
4 Replies

Featured Tech Videos