PatternCountCS ( Text ; TextToSearchFor )

Same as PositionCS, but without any limitation. Slower!

Average rating: 4.3 (35 votes) Log in to vote

Christian JÃ¤ger
contact: cjaeger @ www.fmforums.com
Hannover, Germany

Sample input:

PatternCountCS("aAaAaA";"a")

Sample output:

3
(not 6 !!!)

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

let( [ 
marker ="•••"; 
Text = Replace(Text;TextToSearchFor; marker & TextToSearchFor) // redefine "Text" 
]; 

PatternCount(Text; marker & TextToSearchFor) 
) //end let

see also PositionCS() and PositionCSE().

I have also written an ASCII-Coder:
Num2Char(NUM)
and
Char2Num(CHAR)
which work using the same technique enploying all 256 characters (one Exception: #00 needs to be pasted into a global. It cannot be used in FileMaker 7s calculations nor in a evaluated field without FileMaker crashing. So I just reference the global "NULL" in Num2Char()'s output
However, this cannot be shown here - I will post a sample file at http://www.fmforums.com soon.

Comments

		databaser, CA Dec 15, 2011
I wanted to use this but it doesn't work. It's missing the second parameter in the replace function. When I put '1' for this, it doesn't work. It seems to give '1' as the result no matter what.

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

PatternCountCS ( Text ; TextToSearchFor )

Comments

Support this website.

Support this website.