Brian Dunning's FileMaker Custom Functions

ListMinusAnyCase ( InList ; InValue )

Remove 1st occurance from list, regardless of case.

  Average rating: 3.9 (20 votes) Log in to vote

Richard DeShong   Richard DeShong
Logic Tools
http://logictools.com

Share on Facebook Share on Twitter

  Sample input:
"A¶b¶a¶c" ; "a"
  Sample output:
b
a
c

  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.

 

Comments

Thomas Hellwig   Thomas Hellwig, Hamburg/Germany
May 1, 2016
The CF removes just the first occurrence of InValue.

Input
ListMinusAnyCase ( "a¶b¶c¶d¶a¶b¶c¶d¶a¶b" ; "a" )

Output
b
c
d
a
b
c
d
a
b

No output like this:
"b¶c¶d¶[...]"
 
Richard DeShong   Richard DeShong, Logic Tools
May 4, 2016
Thanks Thomas. I've indicated in the description that it removes just the 1st occurance.
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.