truelifeajf Posted October 22, 2013 Share Posted October 22, 2013 Can anyone tell me why: PatternCount ( "¶3¶3¶3¶" ; "¶3¶" ) yeilds a result of 2 ? Link to comment Share on other sites More sharing options...
comment Posted October 22, 2013 Share Posted October 22, 2013 This is actually explained in the help on the function: http://www.filemaker.com/12help/html/func_ref3.33.77.html#1031282 The function is not inclusive. If you're looking for a result of 3, you should be using = ValueCount ( FilterValues ( "3¶3¶3" ; "3" ) ) Note that the wrapping of parameters in returns is not required here. 1 Link to comment Share on other sites More sharing options...
truelifeajf Posted October 22, 2013 Author Share Posted October 22, 2013 All these years! I'm surprised I haven't been tripped up by this lack of knowledge in the past. I only just came across the issue. And I even read the help topic on the function (though not thoroughly enough), so thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3845 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