Splunk Search

Search Field Extraction help

lisaac
Path Finder

I have an _raw event with data that I would like to break out into key value pairs. I was wondering if anyone had any suggestions on how to best accomplish this task at search time based on the following data set:

<COL ID='CARDS_ALIAS_ID'>1111111</COL><COL ID='PROFILE_ALIAS_ID'>44444444</COL><COL ID='TXT_MSG_TYP_2'>5555</COL>

I would like to have the fields CARDS_ALIAS_ID, PROFILE_ALIAS_ID, and TXT_MSG_TYP_2.

Tags (3)
0 Karma

gkanapathy
Splunk Employee
Splunk Employee

Seems pretty likely that:

[mysourcetype]
EXTRACT-xml = \<COL\s+ID=\'(?<_KEY_1>[^\']+)\'\>(?<_VAL_1>[^\>]+)\<\/COL\>

should do it.

Get Updates on the Splunk Community!

New Splunk Observability innovations: Deeper visibility and smarter alerting to ...

You asked, we delivered. Splunk Observability Cloud has several new innovations giving you deeper visibility ...

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...