FileMaker Pro Custom Functions

How about:

Let (
nope = IsEmpty ( FilterValues ( theList ; value ) ) ;

If ( nope ;
List ( theList; value );
Substitute( theList & ¶; value & ¶; "" )
)
)

Bruce Robertson, Redmond WA
March 09, 2009 10:57am

This function is does not work 100%. If you had "apple banana pineapple" and the item is "apple", you would end up with "banana pin".

Bernard Cheang, Singapore
March 09, 2009 5:23pm

Hi Bruce
I had something like that early in testing. I tested yours but it leaves a trailing return every time you remove an item. That was the purpose of the second listminusitem setting. ;)

Hi Bernard
Good catch! I have updated the CF to trap for cases where the value being removed is the end of the last value. I have used <EOL> to signify end of list. If you were happy to limit the use of the CF to version 10+ then you could use some formal ASCII character with the Char function. But I think this should be sufficient for most data. Thanks for the feedback.

David Head, Darwin Australia
March 10, 2009 12:07am

Hmmm, further testing revealed the problem was not just if the value being tested was the end of the last value - it occurred if it was the end of ANY value.

I have updated the listminusitem variable expression to fix this issue. Seems to work consistently now.

Note that this CF does not return any trailing returns in the result.

David Head, Darwin Australia
March 10, 2009 1:15am

Good job, David. I was looking for a similar function. Didn't have time to fix it myself. Thanks.

Bernard Cheang, Singapore
March 10, 2009 5:34pm