value.remove.cs ( a_list ; a_value )

removes a_value from a_list // *.cs = Case Sensitive

Be the first to rate this function Log in to vote

Tony White - Show more from this author
Tony White Designs, Inc.
http://www.twdesigns.com/

Sample input:

value.remove.cs ( "123¶456¶789" ; 456 )

Sample output:

"123¶789"

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

// CF: value.remove.cs ( a_list ; a_value )
// twdesigns.com 2021-04-30_v1


Let ( 
[ 
~a_list.padded = ¶ & a_list & ¶  ;
~a_value.padded = ¶ & a_value & ¶  ;
~a_list.after.padded = Substitute ( ~a_list.padded ; ~a_value.padded ; ¶ ) ;

~numberOfCharacters = Length ( ~a_list.after.padded ) - 2 ;

~a_list.after = Middle ( ~a_list.after.padded ; 2 ; ~numberOfCharacters )

] ;
~a_list.after   // result
)

One of the value.* suite of Custom Functions for working with FileMaker Lists and Values.
One use case is when working with lists of RecordIDs.

Comments

		flusheDData, n/a May 1, 2021
Hi Tony. I created a funcion based on your one. It removes an existing item or adds a non existing one. Thank you so much for the inspiration. Best regards, Miguel https://www.briandunning.com/cf/2491

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

value.remove.cs ( a_list ; a_value )

Comments

Support this website.

Support this website.