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
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...