Getting Data In

How can I remove a string from a source name?

New Member

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?

0 Karma

Legend

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

New Member

thanks cusello and kamlesh, i will try your suggestions.

0 Karma

SplunkTrust
SplunkTrust

Hi

Can you please try below search?

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

Thanks

0 Karma