Splunk Search

How to extract everything after a carriage return?

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

SplunkTrust
SplunkTrust

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

SplunkTrust
SplunkTrust

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

Explorer

That worked fantastically. Thanks.

0 Karma

SplunkTrust
SplunkTrust

What do you want to get from the provided example?

0 Karma

Explorer

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

0 Karma