Patterncount not working ?

[truelifeajf]

Can anyone tell me why:

 

PatternCount ( "¶3¶3¶3¶" ; "¶3¶" )

 

yeilds a result of 2 ?

[comment]

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.

[truelifeajf]

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