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!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...