Steven Cappiello Posted September 8, 2006 Share 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.. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 8, 2006 Share Posted September 8, 2006 Add a pilcrow after John.... --sd Link to comment Share on other sites More sharing options...
John Mark Osborne Posted September 8, 2006 Share Posted September 8, 2006 patterncount("¶" & valuelistite ms() & "¶"; "¶John¶") Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6532 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 accountSign in
Already have an account? Sign in here.
Sign In Now