Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

DeleteValue ( list ; index )

Returns a list with value at position 'index' removed

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

Theo Ros - Show more from this author

  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 -------------------------------------------------------------------------------- */ Let ( [ list = LeftWords ( list ; 999999999 ) ; totalvalues = ValueCount ( list ) ] ; Case ( index < 1 or index > totalvalues ; list ; LeftWords ( LeftValues ( list ; index - 1 ) & MiddleValues ( list ; index + 1 ; 999999999 ) ; 999999999 ) ) ) Click to copy

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, 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, 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 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 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 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 20 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: