Can I use regex to remove a pipe character from a string?

[MikeElliott]

Hi All,

I am having a problem with my search output. One of the results contains a pipe ( | ) - E.g. bad_domain|www.baddomain.com.

Once run, the search results are passed to a 3rd party tool that uses pipes as formatting options - This rogue pipe is being picked up as a formatting option. I would like to know how to remove, or replace, the pipe in my search results, for example:

bad_domain|www.baddomain.com to bad_domain_www.baddomain.com, or bad_domain-www.baddomain.com.

Can anyone assist?

[HiroshiSatoh · Accepted solution]

try this!

(your search)|eval text=replace(text,"\|","_")

Please change TEXT to field name.

[MikeElliott]

Worked perfectly - Thank you so very much!