Getting Data In

How can I remove a string from a source name?

navins007
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

gcusello
SplunkTrust
SplunkTrust

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
New Member

thanks cusello and kamlesh, i will try your suggestions.

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

Hi

Can you please try below search?

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

Thanks

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...