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
Logic Tools
http://logictools.com

Sample input:

"A¶b¶a¶c" ; "a"

Sample output:

b
a
c

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

Let( [
  toRemove = "¶" & InValue & "¶" ;
  toRemoveLen = Length ( InValue ) ;
  fromList = "¶" & InList & "¶" ;

  Start = Position( fromList ; toRemove ; 1 ; 1 ) ;
  Start = Start + Case( Start = 0 ; Length ( fromList ) ) ;

  ListMinus = Replace ( fromList ; Start + 1 ; toRemoveLen + 1 ; "" )
];
  Middle ( ListMinus ; 2 ; Length ( ListMinus ) - 2 )
)
// Remove 1st occurance of InValue from InList, regardless of case.

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, 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, 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.

ListMinusAnyCase ( InList ; InValue )

Comments

Support this website.

Support this website.