Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Identifying duplicate entries in a list

Posted on 2004-09-03
5
Medium Priority
?
257 Views
Last Modified: 2013-12-18
I have a field on a form which is a list of names, and need to check to see if there are any duplicates. I want to do this using a separate calculated field which will list any entries that appear more than once in the source field.

How do I do this using a formula. My best guess is to use the @Unique function and then compare this to the original list, but I'm not if this is possible.

Help would be appreciated!

0
Comment
Question by:mrt1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 15

Expert Comment

by:Bozzie4
ID: 11974037
Why would you bother to see which are the duplicates ?
Just put in a Translation formula, to get rid of the duplicates :

@unique(TheField)

cheers,

tom
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11974184
Or, if you really want to know, use
    @If(@Elements(TheField)=@Elements(@Unique(TheField)); @Success; @Failure("..."))
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 11976162
Here is the formula to extract duplicates from a List

List := FIELD_NAME_HERE;
num := "0" : "1" : "2" : "3" : "4" : "5" : "6" : "7" : "8" : "9";
idList := @Subset( num*+ num; @Elements(List));
tmp1 := @Unique(@Replace(List; List; idList));
tmp2 := @Trim(@Replace(idList; tmp1; ""));
@Replace(tmp2; idList; List);

~Hemanth
0
 
LVL 2

Author Comment

by:mrt1
ID: 12008206
My 'list' is actually a concatenation of several list fields - that is why I'm looking for duplicates. I need to return the duplicates themselves - not just a boolean value. This calculated field is going to be displayed on the form as a validation warning -so that users are made aware of the duplicates.

Isn't there a more elegant way of doing it that having to hard code a list of numbers ( There isn't an upper limit to the number of entries in the list, so I don't really want to do this).
I could probably do this using Lotus script, but I just thought it would be simpler using a formula.
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 800 total points
ID: 12008274
That is what my formula does.. it returns the duplicates...

list of numbers can be expanded upto any value.. right now it give 100 values.. but it can be increased by appending *+ num to the existing one

eg:
num*+ num*+ num will give 1000 values, num*+ num*+ num*+ num yields 10000 values
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question