Splunk Search

Data Onboarding line break at empty lines

inventsekar
SplunkTrust
SplunkTrust

Hi.. 

Spent some one or two hrs, but no luck, hence posting here.. the sample logs:

1.1.1. test log a
1.1.1. test log abc

1.1.2. test log b
1.1.2. test log bcd

one thing - no need to worry about timestamps. 

one log will have around 10 events.
the lines with the starting 1.1.1. should be one event, 1.1.2. should be next event and so on.. 

or simply, the empty lines should break the events. 

please suggest, thanks. 

Labels (1)
0 Karma
1 Solution

yeahnah
Motivator

Hi @inventsekar 

Give this ago...

 

SHOULD_LINEMERGE=false
LINE_BREAKER=([\r\n]\s[\r\n]+)

 

 

 Not exactly sure why the \s makes a difference - regex101 says \s matches any whitespace character (equivalent to [\r\n\t\f\v  ]) - but it tested OK when I used it 

yeahnah_0-1684376337450.png

Hope that helps

View solution in original post

0 Karma

inventsekar
SplunkTrust
SplunkTrust

wow, @yeahnah you are a life saver ! thanks a ton! 

0 Karma

yeahnah
Motivator

FYI - it's the \v metacharacter that makes it work.  From the references I found it means vertical tab or vertical whitespace character, which in this instance would equate to the blank line.

0 Karma

yeahnah
Motivator

Hi @inventsekar 

Give this ago...

 

SHOULD_LINEMERGE=false
LINE_BREAKER=([\r\n]\s[\r\n]+)

 

 

 Not exactly sure why the \s makes a difference - regex101 says \s matches any whitespace character (equivalent to [\r\n\t\f\v  ]) - but it tested OK when I used it 

yeahnah_0-1684376337450.png

Hope that helps

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...