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?
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.