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?