Convert Craig%40gmail.com to craig@gmail.com

[craigpbrown]

Hi,

Probably a simple answer, but how do I convert %40 to @. For example craig%40gmail.com to craig@gmail.com

Thanks in advance,
Craig

[richgalloway]

For the specific case, try the replace command

... | replace "%40" with "@" in foo | ...

or the replace function

... | eval foo = replace(foo, "%40", "@") | ...

For the more general case of any URL-encoded character, try the urldecode function

... | foo = urldecode(bar) | ...

[somesoni2]

+1 for urldecode function use.