_PatternCount ( Text ; TextToSearchFor ; isCaseSensitive )

Provides an option to turn on or off the case sensitivity of the PatternCount function.

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

_PatternCount ( "Test123, just a test" ; "test" ; 0 )
&¶&
_PatternCount ( "Test123, just a test" ; "test" ; 1 )

Sample output:

2
1

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let( [ 
	 marker = If( isCaseSensitive; "•••"; "" )
	;Text = Substitute(Text;TextToSearchFor; marker & TextToSearchFor) // redefine "Text" 
]; 

	PatternCount(Text; marker & TextToSearchFor) 

)

Since FileMaker's PatternCount function is not case sensitive, we need to have a way sometimes to be able to perform a pattern count for case sensitive text. This custom function solves that need.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

_PatternCount ( Text ; TextToSearchFor ; isCaseSensitive )

Comments

Support this website.

Support this website.