Splunk Search

How to extract everything after a carriage return?

ruhjuh
Explorer

Is it possible to get everything after a carriage return?

Example

Bills to pay:
Car
House
Boat
etc

I tried to use rex :

"[\r\n]+(?<Sites>.*)" 

but this did not work.

1 Solution

MuS
Legend

Hi ruhjuh,

try this regex:

base search here | rex "pay:[\r\n](?<site>[^$]+)" | table site

it will match Car House Boat etc from your example.

cheers, MuS

View solution in original post

MuS
Legend

Hi ruhjuh,

try this regex:

base search here | rex "pay:[\r\n](?<site>[^$]+)" | table site

it will match Car House Boat etc from your example.

cheers, MuS

ruhjuh
Explorer

That worked fantastically. Thanks.

0 Karma

MuS
Legend

What do you want to get from the provided example?

0 Karma

ruhjuh
Explorer

I'd like to get from the example "Car House Boat etc"

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...