GetWords ( text ; string )

It returns all the words that contain a given string

Average rating: 4.1 (31 votes) Log in to vote

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

GetWords("Apples and oranges are good fruits"; "r")

Sample output:

oranges
are
fruits

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

/*
Author
Daniele Raybaudi

modified: 01/30/2013
first try: 09/11/2005
*/

Let ( [
word = LeftWords ( text ; 1 ) ;
count = PatternCount ( word ; string ) ;
recursion = GetWords ( RightWords ( text ; WordCount ( text ) - 1 ) ; string ) 
] ;
Case (
not IsEmpty ( word ) ; If ( count ; List ( word ; recursion ) ; recursion )
)
)

It returns all the words that contain a given string in a return delimited format.

Comments

		Dorian Cougias, Oakland Jan 21, 2011
Um, this is in Italian. Can anyone put this into English?

		David Jan 30, 2013
Dear Friend: I would like to use your function, but you haven't published the internal functions that use.

		Daniele Raybaudi, ACI Jan 30, 2013
Hi that was an old attempt to write a CF. Try the modified one.

		Oak, California Oct 7, 2014
Get an 'out of memory error" using the example. FMP12

		Raybaudi, Rome Oct 7, 2014
This custom function works with 9999 as the max number of recurtions. If your text contains more words, the result is a "?"

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

GetWords ( text ; string )

Comments

Support this website.

Support this website.