ListMinus1st ( InList ; InValue )

Remove 1st occurrence from list.

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 occurrence of InValue from InList.

Remove 1st occurance of InValue from InList.
Note that Position() is case-insensitive.

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.

ListMinus1st ( InList ; InValue )

Comments

Support this website.

Support this website.