Brian Dunning's FileMaker Custom Functions

PatternCountCS ( Text ; TextToSearchFor )

Same as PositionCS, but without any limitation. Slower!

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

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

Share on Facebook Share on Twitter

  Sample input:
PatternCountCS("aAaAaA";"a")
  Sample output:
3
(not 6 !!!)

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

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   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.
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.