ListMinusAnyCase ( InList ; InValue )
Remove 1st occurance from list, regardless of case.
Average rating: 3.9 (20 votes) Log in to vote
Richard DeShong - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Remove 1st occurance of InValue from InList, regarless of the case of either.
The usual technique for removing a value is to force the list and value to the same case using Upper() or Lower(), and then using Substitute().
This method is good if you only want to remove the 1st occurance.
|Thomas Hellwig, Hamburg/Germany
May 1, 2016
|The CF removes just the first occurrence of InValue.
ListMinusAnyCase ( "a¶b¶c¶d¶a¶b¶c¶d¶a¶b" ; "a" )
No output like this:
|Richard DeShong, Logic Tools
May 4, 2016
|Thanks Thomas. I've indicated in the description that it removes just the 1st occurance.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.