Replace (Prod by XXX) to [Prod. by XXX]

Scripting functions can be used in format strings.
So an action of the type "Format value" would be good. Or the Converter>Tag-Tag.

You have not yet mentioned which field you want to modify.