Newest functions Upload a function Leave a tip My account

There are 2,610 functions in this library.

OmitValuesThatMatchAString ( ListToFilter ; StringToUse )

To remove values from a list that contain a certain string

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

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

  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 Click to copy

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!!

		Nick Lightbody, Deskspace Corporation Limited Oct 9, 2025
Hi, very useful - thanks - my reward I guess finding this just after sending Mr D some $. Appreciated, Nick

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: