REReplace: Manipulating Backreferences

[Jamie Jackson]

I just wrote a UDF to do a rereplace with manipulated backreference
values. Specifically, it replaces all instances of email addresses in
a string with "antiSpam" email addresses.

However, I'm wondering if there was an easier way...

Is there any magic shortcut, similar to this (illegal) pseudo-code?
(i.e. Is there a way to manipulate the backreferenced value within the
rereplace function?)

rereplace(str,
          "([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+",
          emailAntiSpam(\1),
          "all");

Thanks,
Jamie

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---