Knowledge Management

problem extracting empty values

Be_JAR
Path Finder

Hi all,

I am ingesting data and I have  a problem :

event example:
field1 = /var/log/asas/log1.log
field2 = /var/log/as/as/log2.log
field3 = /var/log/as/as/log3.log

in the sourcetype (props.conf) I do it like this:
^.*field1 \=\s*(?<log1>.*?)\s*\n
^.*field2 \=\s*(?<log2>.*?)\s*\n
^.*field3 \=\s*(?<log3>.*?)\s*\n

The problem is when the value of some field appears empty. In that case capture the following line. like this:

source:
field1 = /var/log/as/as/log1.log
field2 = 
field3 = /var/log/log/as/log3.log

result:
log2= field3 = /var/log/logs/log3.log

 

I'm sure there is a way to fix it and make the field appear empty, but I can't find it. Does anyone know how to do it?

 

BR

JAR

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

(?m)^.*field1 \=\s*(?<log1>\S*?)\s*\n
(?m)^.*field2 \=\s*(?<log2>\S*?)\s*\n
(?m)^.*field3 \=\s*(?<log3>\S*?)\s*\n

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

(?m)^.*field1 \=\s*(?<log1>\S*?)\s*\n
(?m)^.*field2 \=\s*(?<log2>\S*?)\s*\n
(?m)^.*field3 \=\s*(?<log3>\S*?)\s*\n
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Supercharging Windows Security Detection Performance: Introducing Hybrid Field ...

Windows event logs—from Security auditing and Sysmon to PowerShell script blocks—form the operational backbone ...

Ditch the Manual Grind: Building AI Agents with Splunk

Ditch the Manual Grind: Building AI Agents with Splunk Let’s be real: your team’s time is being eaten alive. ...

Cisco Data Fabric from Architecture to Investigation, Better SOC Visibility, and More ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...