Correct parameter to remove (replace) section of text in a string in db field

Hey all,

Simplified a workflow by adding each new text item in a string, now when the user deletes this selection i’d like to remove it from the string.

So right now, I might have:

item1, item2, item3, item4

I can easily keep adding new items.

I’m looking at an update query, and using the ‘Replace String’ formatter. I can search for ‘item3’ for example, but need to ensure I remove the entire section, e.g. ', item3 - so the field is ready for new additions.

What would be the correct ‘Replace with’ parameter property to use to remove the above?

Would ‘’ do it?

Screen Shot 2020-09-15 at 10.33.06 am361×717 18.2 KB

UPDATE: I can confirm this kind of works, but it does leave behind the ‘’ within the db field, and if I remove this and replace with a space then I’ll just add additional spaces between each records. Not the biggest deal - but if anyone has the right parameter or approach to remove a text item from a string that would be appreciated.