Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

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