Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext


~Mario Rejipyzenader 10.Mar.07 12:30 PM a Web browser
Domino Designer 7.0.2 Windows XP


Before I switch to LS to do this, I thought I'd ask in here as I feel there could be a really simple and elegant way to do this in formula that I'm overlooking...

I have a list of strings and I'd like to find which string occurs the most often in the list. If there isn't one which occurs more often than the others, just return the first one, e.g:

cat:dog:mouse:dog would return dog

cat:dog:mouse would return cat

I don't know beforehand which values are likely to be in the list, so I can't loop through a list of possible values to do the count.

Anyone got a nice little formula for this?

Thanks,
Emily.








  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS