topic How to extract a key and value from the Raw data? in Getting Data In

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

Stevelim — Wed, 30 Mar 2016 04:00:37 GMT

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.

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

woodcock — Wed, 30 Mar 2016 04:14:56 GMT

In transforms.conf:

Using FORMAT:

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

Not using FORMAT:

REGEX = (?:[^,]*,){2}(?<_KEY_1>[^,]+),[^,]*,(?<_VAL_1>[^,]+)