|
The problem is that for multiple valued columns like tags, search & replace iterates over the individual values (each tag). It doesn't operate on all of them at once. Thus the regular expression is applied to each tag, not the string of all tags.
You can get around this by using *template as the input field, where the template is something like {tags}. The result of a template is a single value, not multiple values, even if it contains commas. This causes S&R to operate on the single value, not individual ones.
You could even get fancier and have the template generate the value you actually want in the destination column, eliminating the regex. This would be useful mostly if splitting apart the tags requires some logic & conditionals, which doesn't seem to be the case here.
|