Shopping Cart
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
AddRemove ( value ; content ) Rate this function:    Discuss this Custom Function Matt Petrowsky, ISO Productions, Inc. A custom function which allows simple addition or extraction of values from a list.
Description:This function is a simple tool. It simply adds or removes a value from a return delimited list of values. The area where this is most useful is when working with portals and clicking a portal row to add or remove an ID value from a global field storing a multi-key value. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
I have added the RightValues functions so you do not have to add an "¶" to the content parameter. To be sure the list closes with an enter.
Let (
[
content =RightValues ( ( content );ValueCount ( content ));
value_exists = PatternCount ( "¶" & content & "¶" ; "¶" & value & "¶" )
]
;
Case (
value_exists; MiddleValues ( Substitute ( "¶" & content; "¶" & value & "¶" ; "¶" ) ; 2 ; 1000000 );
content & value & "¶" )
)
Willem-Jan, Hiversum
January 06, 2010 7:48am