topic Re: How can I remove a string from a source name? in Getting Data In

How can I remove a string from a source name?

navins007 — Fri, 17 Nov 2017 00:18:13 GMT

below is my search

source=abc-server

I want to trim "-server"

and I tried this

| eval source=trim("abc-server", "-server")

did not work any idea how to do this?

kamlesh_vaghela — Fri, 17 Nov 2017 08:15:49 GMT

Can you please try below search?

YOUR_SEARCH | rex field=source "(?<source>.*)\-.*"

Thanks

gcusello — Fri, 17 Nov 2017 08:16:21 GMT

Hi navins007,
the easiest way is a regex:

| rex field=source "(?<source>[^-]*)-server"

or, if the string before "-server" has a fixed lenght

| eval source=substr(source,1,string_lenght)

but regex is better and more efficient!
Bye.
Giuseppe

navins007 — Fri, 17 Nov 2017 18:54:18 GMT

thanks cusello and kamlesh, i will try your suggestions.