Getting Data In

How to extract a key and value from the Raw data?

Stevelim
Communicator

While I understand the regex command and click based extraction of data fields. How do I extract both of them via the raw data?

For example:

$ABCD,,Speed,Nmea,63*33

From these, I will like to have a key Speed = 64 for example. I am guessing I need to perform some regex at the transforms.conf. But I am not exactly sure how to start.

0 Karma

woodcock
Esteemed Legend

In transforms.conf:

Using FORMAT:

REGEX = (?:[^,]*,){2}([^,]+),[^,]*,([^,]+)
FORMAT = $1::$2

Not using FORMAT:

REGEX = (?:[^,]*,){2}(?<_KEY_1>[^,]+),[^,]*,(?<_VAL_1>[^,]+)
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...