RemoveValues ( listOfValues ; valueNumbers )

Removes values in positions given by valueNumbers from listOfValues.

Average rating: 4.3 (15 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

RemoveValues ( "Red¶Cyan¶Green¶Magenta¶Blue" ; "5¶1¶3" )

Sample output:

Cyan
Magenta

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

/*
RemoveValues function

Author
*COMMENT Visual Realisation

Format
RemoveValues ( listOfValues ; valueNumbers )

Parameters
listOfValues - a list of carriage return-delimited values
valueNumbers - a list of carriage return-delimited numeric values

Data type returned
text

Description
Removes values in positions given by valueNumbers from listOfValues. 

September 21, 2016
*/

Let ( 
n = ValueCount ( listOfValues )
;
If ( n > 1 ; RemoveValues ( LeftValues ( listOfValues ; n - 1 ) ; valueNumbers ) )
&
If ( IsEmpty ( FilterValues ( n ; valueNumbers ) ) ; RightValues ( listOfValues ; 1 ) )
)

Removes values in positions given by valueNumbers from listOfValues. Positions can be listed in any order.

As with all value functions, the result of RemoveValues() has a trailing carriage return.

Comments

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

RemoveValues ( listOfValues ; valueNumbers )

Comments

Support this website.

Support this website.