PositionCSE ( Text ; TextToSearch ; Start ; Occurrence )

Same as PositionCS, but without any limitation. Slower!

Average rating: 4.4 (33 votes) Log in to vote

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

Sample input:

PossitionCSE("AbbABBaBb";"ABB")

Sample output:

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

Let( [ 

charList ="#•%$§!"; 
marker = 
Middle(charList; Int(Random*5)+1;1)  & 
Middle(charList; Int(Random*5)+1;1)  & 
Middle(charList; Int(Random*5)+1;1) 

]; 

If(PatternCount(Text;marker) = 0; // hopefully, the marker string  is not found in the Text 
Position( 
Replace(Text;TextToSearchFor; marker & TextToSearchFor)  ; //redefine "Text" 
marker & TextToSearchFor;Start;Occurrence) // now we search for the combined string 
- (Occurrence-1) * Length(marker)   //subtract the # of charachters added before 
; 
PatternCountCSE(Text;TextToSearchFor)  // simply call the function again if marker is already in Text 
)  //end if 
) //end let

see PositionCS. This function works alsways, since the marker string is not fixed.

It generates a random marker string, checks if it's already contained, and if yes, simply calls the function again. Note, however, that this function takes longer to compute, which can be an issue with large databases. So rather choose your marker string appropriately ...

Maybe someone volunteers to compiles a list of FMP7 functions which are Case-Insensitive & writes a ..CS and ..CSE version of all of them ???

Se also PatternCountCS.

Comments

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

PositionCSE ( Text ; TextToSearch ; Start ; Occurrence )

Comments

Support this website.

Support this website.