Splunk Search

Data Onboarding line break at empty lines

inventsekar
Ultra Champion

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
Ultra Champion

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!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...