We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

unique entries in a variant

BillTr
BillTr asked
on
Medium Priority
510 Views
Last Modified: 2013-12-18
Is there a way to leverage variants to deal with unique data? Example: If I pull the dept names for a list of people, but only only want to store each dept name once. Currently my code sorts the data and does compares of the current Dept  to the last one used.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
what language are you using? can you just do @unique(deptnames) ?
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT
Commented:
Or, 100% equivalent to theprevious post, but in LotusScript:
      v= Eval("@Unique(deptnames)",doc)
or
      v= Eval(|@Unique("| & (Join(deptnames,|":"|) & |")|)
depending on where the values are.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Commented:
Ehhh Sjef, is there anything wrong with ArrayUnique(sourceArray [,compMethod ])?
(nothing personal, buddy!)
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
Ehm, well, now, right, oooops... Just wanted to show that "clever" things can be done using Eval()... Not so clever after all, apparently...

Is there a backdoor in this room??
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.