OmitValuesThatMatchAString ( ListToFilter ; StringToUse )

To remove values from a list that contain a certain string

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

Maarten Witberg - Show more from this author
http://www.maatwerkdbs.nl

Sample input:

OmitValuesThatMatchAString ( Red¶Blue¶Grey¶Orange¶Yellow ; r )

Sample output:

Blue¶Yellow

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

Let
(
[
Count = ValueCount ( ListToFilter) ;
Current =  LeftValues ( ListToFilter; 1 );
Include = Case ( not PatternCount ( Current ; StringToUse) ; Current )
];
Case
( 
Count>0;
include &  OmitValuesThatMatchAString ( RightValues( ListToFilter; count-1 ) ; StringToUse) ;
include
)
)

//maarten witberg©2007
//aka kjoe from filemaker cafe

This function removes values from a return separated list that contain a certain string.

Comments

		Andrea_M, Bancomail SpA May 16, 2023
wow, superb, thanks!!

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

OmitValuesThatMatchAString ( ListToFilter ; StringToUse )

Comments

Support this website.

Support this website.