AnsweredAssumed Answered

Replace/Delete values in value list help

Question asked by BobSchwenkler on Jun 13, 2012
Latest reply on Jul 28, 2012 by BobSchwenkler


Replace/Delete values in value list help


I've got a global field that's being used as a multi-key match field for a portal. The user clicks on a portal row and that ID number is added or subtracted from the global field. I started out using Substitute(valueList;valueToDelete & ¶;""). Only problem is if I've got eg. 28¶8¶ in my field, performing this function with valueToDelete=8 will return 2¶.

I'm having a hard time thinking of a way to do this with the stock functions, and wondering if I'll need to create a recursive function to loop through the value list and look for exact matches. Thoughts?