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, Germany
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.
 
Gilles Plante   Gilles Plante
Mar 5, 2019
Hi,

there is an issue with this CF, list is not acceptable as a name for a parameter. I am running FMPA 17. Maybe in the past that was not a problem, but now it is.
 
Gilles Plante   Gilles Plante
Mar 11, 2019
Hi,

there is an issue with this CF, list is not acceptable as a name for a parameter. I am running FMPA 17. Maybe in the past that was not a problem, but now it is.
 
Gilles Plante   Gilles Plante
Mar 14, 2019
Hi,

there is an issue with this CF, list is not acceptable as a name for a parameter. I am running FMPA 17. Maybe in the past that was not a problem, but now it is.
 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: