RemoveWords ( text ; toRemove )

Eliminates any/all words in a list from text

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

Tim Anderson - Show more from this author
Tim Anderson Group

Sample input:

RemoveWords ( "Leave only result" , "only¶leave" )

Sample output:

result

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

 Case ( IsEmpty(text); ""; 
           IsEmpty(toRemove); text; 

           Let ( [ item = LeftWords( text; 1 ); 
                    remain = RemoveWords( RightWords( text; WordCount(text)-1 ); toRemove ) 
                   ]; 

              If ( IsEmpty( FilterValues( item; toRemove ) ); 
                   item & " " & remain; 
                   remain 
              ) 
           ) 
 )

Very obviously based on the RemoveValues function, adapted to remove words from text. Created because I wanted to be able to remove common words from company name fields for simplified searching. For example when searching for 'The Filemaker Developers Company ltd' I will have a global for the toRemove containng words and abbreviations such as 'the', 'ltd', 'inc', 'co' giving me a key field of 'Filemaker Developers Company'. Then i will break this down using FilterKey nad FieldBeginsWith functions

Comments

		Jamie Woods, Brisbane, Australia Feb 2, 2015
This doesn't work when trying to use a Script Parameter. Workaround; Set the Script Parameter as a Variable at the beginning of a script Example; Set Field[gField::g1;RemoveWords(gField::g1;get(ScriptParameter)] Does not work. but, Set Variable [$SP; Value:Get(ScriptParameter)] Set Field[gField::g1;RemoveWords(gField::g1;$SP] Does work.

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

RemoveWords ( text ; toRemove )

Comments

Support this website.

Support this website.