Getting Data In

Parsing comma separated values

danurag
Explorer

I have a script that outputs data in the following format. The problem is that the value of the Error field gets initialized to "No" and ignores the Error part. Also, the Error field could have have a completed stack trace and flow into multiple lines. How do I write the transforms stanza so that it assigns all the values to the "Error" field.

ElapsedTime=2.2812208, StatusCode=OK, ContentMatched=False, Error=No Error

Thank you

Tags (1)
0 Karma

yannK
Splunk Employee
Splunk Employee

try the inline regex,

mysearch | rex field=hop "Error=(?<Error>([^=]*)$)" | table Error

then once confirmed working, you can define an automatic field extraction
see http://docs.splunk.com/Documentation/Splunk/4.2.5/Knowledge/Managesearch-timefieldextractions

danurag
Explorer

Hi MuS, I need help with writing the complete regex. Could you please give me some pointers.

Thanks.

0 Karma

MuS
SplunkTrust
SplunkTrust

Hi danurag

you can use a regex like this ([^=]*)$ to match everything after the last = to be extracted

cheers

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!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...