ListRemoveValue ( valueList ; RemoveValue )

Removes a specified value from a pilcrow delimited list using the While() function

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

ListRemoveValue ( "Apple¶Orange¶Banana¶Orange" ; "Orange" )

Sample output:

"Apple¶Banana"

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

/*
  __  __                 _      _ _               _     _     _     ____ 
 |  \/  | __ _ _ __   __| | ___| | |__  _ __ ___ | |_  | |   | |   / ___|
 | |\/| |/ _` | '_ \ / _` |/ _ \ | '_ \| '__/ _ \| __| | |   | |  | |    
 | |  | | (_| | | | | (_| |  __/ | |_) | | | (_) | |_  | |___| |__| |___ 
 |_|  |_|\__,_|_| |_|\__,_|\___|_|_.__/|_|  \___/ \__| |_____|_____\____|

*/

While ( 

 [
   vals = valueList ;
   removeKey = RemoveValue;
   endCount = ValueCount ( vals ) ;
   thisValue = GetValue ( vals ; 1 ) ;
   newList = "" ;
   i = 1
 ] ;
 i < endCount + 1 ;
 [
   newlist = If ( thisValue = removeKey ; newList ; If ( newList = "" ; thisValue ; newList & "¶" & thisValue ) ) ;
   i = i + 1 ;
   thisValue = GetValue ( vals ; i )
 ] ;
 newList

 )

Version 1, 2024-04-08
A modern take on older custom functions that use tail recursion.
This one uses the While() function instead, so it requires FileMaker 18 or later.

Comments

		David Zakary May 19, 2023
What if you want to remove multiple values (other than repeat the function)?

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

ListRemoveValue ( valueList ; RemoveValue )

Comments

Support this website.

Support this website.