PatternCountMulti ( Text ; SearchList )

Searches for any value of a list in a text.

Average rating: 5.0 (1 vote) Log in to vote

flusheDData - Show more from this author
n/a
http://www.udias.com

Sample input:

PatternCountMulti ( "The more I type, the more I mistype" ; "the¶more")

Sample output:

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

Let ( [ 
$counter = $counter + 1 ; 
$searchTerm = GetValue ( SearchList  ; $counter )  ; 
$result = $result + PatternCount ( Text ; $searchTerm ) 
] ; 
	Case (
		$counter < ValueCount ( SearchList ) ; 
		PatternCountMulti ( Text ; SearchList ) ; 
		Let ( [ 
		~result = $result ; 
		$searchTerm = "" ; 
		$result = "" ; 
		$counter = ""
		] ; 
		~result
		)
	)
)
/*
flusheDData 2020
flusheddata@gmail.com
*/

It works the same as the PatternCount function, but it can search for many patterns separated by carriage returns.

Comments

		Tjebbe van Tijen, IMP Oct 5, 2024
very useful... I did get stuck a bit when using a calculation script stept to construct the SearchTerm parameter as a non-professional-programmer I did not manage to get the list of search terms [ $code ] with carriage returns to be recognised by this function... till it dawned on me I had to use VALIDATE to the parameter in my solution that looks like this: PatternCountMulti ( aray_creat::xBlock_procs;Evaluate ( "\"" & $code & "\"")) and it works like a charm now.

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

PatternCountMulti ( Text ; SearchList )

Comments

Support this website.

Support this website.