Jump to content

Claris Engage 2025 - March 25-26 Austin Texas ×

counting exact values in a list

Steven Cappiello

By Steven Cappiello
September 8, 2006 in Value Lists

Share

https://fmforums.com/topic/46033-counting-exact-values-in-a-list/

This topic is 6652 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Steven Cappiello

Proficient

Steven Cappiello

Posted September 8, 2006

Posted September 8, 2006

Hi,

Is there a way I can patterncount for exact values in a value list..

so..

from

John

Johnny

Johnnia

Johnnagain

how can I patterncount(valuelistitems(); "John")

so that it = only 1 and not 4 ?

thanks..

Søren Dyhr

Grand Master

Søren Dyhr

Posted September 8, 2006

Posted September 8, 2006

Add a pilcrow after John....

--sd

Mentor

John Mark Osborne

Posted September 8, 2006

Posted September 8, 2006

patterncount("¶" & valuelistite ms() & "¶"; "¶John¶")

This topic is 6652 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Share

https://fmforums.com/topic/46033-counting-exact-values-in-a-list/

Go to topic listing

×

Browse
- Back
- Our Picks
- Blogs
- Clubs
- FM Events
- Events
- Site Support
  - Back
  - Guidelines
  - Staff
  - Feedback
- Gallery
Forums
Blogs
- Back
- Blogs
- Security Blog
Marketplace
Activity
- Back
- Leaderboard
- Online Users
- Search
- All Activity

×

Create New...

Important Information

By using this site, you agree to our Terms of Use.

I accept