Brian Dunning's FileMaker Custom Functions

DeleteValue ( list ; index )

Returns a list with value at position 'index' removed

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

Theo Ros   Theo Ros
n/a
n/a

Share on Facebook Share on Twitter

  Sample input:
DeleteValue ( "John¶Paul¶Brian¶George¶Ringo" ; 3 )
  Sample output:
"John¶Paul¶George¶Ringo"

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

Returns a list with value at position 'index' removed

Syntax: DeleteValue ( list ; index )

In: list - the return delimited list to search
index - the position (1-...) of the value to delete

Return type: Text (a list with leading and trailing returns removed)

DeleteValue ( "John¶Paul¶Brian¶George¶Ringo" ; 3 ) --> "John¶Paul¶George¶Ringo"

Theo Ros

 

Comments

Thomas   Thomas, Bordeaux-France
Sep 16, 2017
This function is usefull but does not work in any circumstances, due to the use of LeftWords function. It does not seem to work properly with values witch are not recognise as words.
 
Theo   Theo, Hilversum/The Netherlands
Sep 25, 2017
Hi Thomas,

yes, the LeftWords function only recognizes "words". That is, if your list contains spaces you will first need to use the Substitute function to replace them with maybe an underscore or like in an url with %20 in order for Filemaker to see these values as a single word.

I'm not doing much with Filemaker nowadays, but i always missed having a real array, so we will have to do with functions like this simulating an that.
 

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.