topic How to replace/remove a specific character? in Splunk Search

How to replace/remove a specific character?

RRajneesh — Thu, 10 May 2018 08:19:43 GMT

Hi,

I have the below output :

"(|01/01/16|01/01/18|01/05/18|04/02/18|05/01/17|05/05/16|05/08/17|)"

The desired output is to remove the first and last '|' : "(01/01/16|01/01/18|01/05/18|04/02/18|05/01/17|05/05/16|05/08/17)"

My below code isn't working, can you please help me?

Let's say search = "(|01/01/16|01/01/18|01/05/18|04/02/18|05/01/17|05/05/16|05/08/17|)"

| eval search = replace (search , "(|" , "(")
| eval search = replace (search , "|)" , ")")

Error : Error in 'eval' command: Regex: missing closing parenthesis

Re: How to replace/remove a specific character?

aholzer — Thu, 10 May 2018 13:57:21 GMT

You have to escape the characters in your regex:

| makeresults 1 
| eval test = "(|01/01/16|01/01/18|01/05/18|04/02/18|05/01/17|05/05/16|05/08/17|)"
| eval test1 = replace (test , "\(\|" , "(")
| eval test2 = replace (test1 , "\|\)" , ")")

Hope this helps

Re: How to replace/remove a specific character?

woodcock — Thu, 10 May 2018 14:22:35 GMT

Like this:

| makeresults
| eval test = "(|01/01/16|01/01/18|01/05/18|04/02/18|05/01/17|05/05/16|05/08/17|)" 
| rex field=test mode=sed "s/\(\|/(/ s/\|\)/)/"

Re: How to replace/remove a specific character?

RRajneesh — Thu, 10 May 2018 16:00:24 GMT

Thanks. - I tried it and it worked.

Re: How to replace/remove a specific character?

wrangler2x — Thu, 10 May 2018 16:21:11 GMT

If this is not a one-time thing, you could also make this replacement before ingesting the data by putting this sed in props.conf on the indexer, or even better on the forwarder:

[sourcetype]
SEDCMD-xyz s/\(\|/(/ s/\|\)/)/