topic Re: How to extract everything after a carriage return? in Splunk Search

How to extract everything after a carriage return?

ruhjuh — Tue, 20 Oct 2015 22:56:23 GMT

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.

MuS — Tue, 20 Oct 2015 23:03:22 GMT

What do you want to get from the provided example?

ruhjuh — Tue, 20 Oct 2015 23:10:18 GMT

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

MuS — Tue, 20 Oct 2015 23:17:03 GMT

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 — Tue, 20 Oct 2015 23:24:11 GMT

That worked fantastically. Thanks.