ExcludePartialValues ( values ; string )

Remove matches from a list that include string

Average rating: 4.2 (20 votes) Log in to vote

Richard Dyce - Show more from this author
Dyce & Sons Ltd.
http://dyce.com

Sample input:

ExcludePartialValues ( "Item List¶item_scripting¶User List¶user_scripting¶Prefs" ; "_scripting" )

Sample output:

Item List
User List
Prefs

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

// ExcludePartialValues ( values ; string )
// Version 3.0
Let (
	[
		numValues = ValueCount ( values ) ;
		topValue  = GetValue ( values ; 1 )
	] ;

	If ( 
		numValues > 0 ; 
		If ( 
			PatternCount( topValue ; string ) = 0; 
			topValue & "¶" 
		) & ExcludePartialValues ( RightValues ( values ; numValues - 1 ) ;  string ) 
	)

)

This is just a convenience function to pull non-scripting values from a list of current layouts.

Comments

		AgnÃ¨s, France Apr 26, 2016
Hi, You can have the same result without recursion Let ([ L = "Item ListÂ¶item_scriptingÂ¶User ListÂ¶user_scriptingÂ¶Prefs" ; No = "_scripting" ; Ln = Substitute ( Upper ( L ) ; Upper ( No ) ; "" ) // or no upper for case sensitive ]; FilterValues ( L ; Ln ) )

		Richard, Zuchwil Apr 26, 2016
AgnÃ¨s, that's very cool. (Slapping my forehead)

		Bruce, Redmond WA Apr 26, 2016
Shouldn't you trap for multiple values in string? Let ([ L = "Item ListÂ¶item_scriptingÂ¶User ListÂ¶user_scriptingÂ¶Prefs" ; No = "_scriptingÂ¶Item" ; Ln = Substitute ( Upper ( L ) ; Upper ( GetValue(No;1) ) ; "" ) // or no upper for case sensitive ]; FilterValues ( L ; Ln ) )

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

ExcludePartialValues ( values ; string )

Comments

Support this website.

Support this website.