fd_AddRemove ( MyList ; MyItem )

Adds an item to a list or removes it if it already exists

Be the first to rate this function Log in to vote

flusheDData - Show more from this author
n/a
http://www.udias.com

Sample input:

fd_AddRemove ( "Alpha¶Bravo¶Charlie¶Delta¶Echo¶Foxtrot" ; "Charlie")

fd_AddRemove ( "Alpha¶Bravo¶Charlie¶Delta¶Echo¶Foxtrot" ; "India")

Sample output:

Alpha
Bravo
Delta
Echo
Foxtrot

--------

Alpha
Bravo
Charlie
Delta
Echo
Foxtrot
India

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

Let ( 
	[ 
	_listWithoutItem = Substitute ( ¶ & MyList & ¶ ; ¶ & MyItem & ¶ ; ¶ ) ; 
	_lengthListWithoutItem = Length ( _listWithoutItem ) - 2 
	] ; 
	Case ( 
		PatternCount ( ¶ & MyList & ¶ ; ¶ & MyItem & ¶ ) ; 
		Middle ( _listWithoutItem ; 2 ; _lengthListWithoutItem ) ;  
		MyList & Case ( not IsEmpty ( MyList ) ; ¶ ) & MyItem
	)
)
/*
flusheDData 2021
Based on the funcion value.remove.cs ( a_list ; a_value ) by 
Tony White from Tony White Designs, Inc.
*/

This function adds an item to a list or removes it if it already exists

Comments

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

fd_AddRemove ( MyList ; MyItem )

Comments

Support this website.

Support this website.