Do share the direction you went, so others can benefit too.
Side note: You should be able to substitute replace(field, regex, "replacement") for your rex mode=sed calls, those should enable your original thought of adding a calculated field. I'd personally prefer that over having to teach people how to use the macro, and people having to use the macro everywhere.
... View more