topic Re: Field extractions with default value in Splunk Search

Field extractions with default value

ltruesda — Tue, 17 Dec 2013 20:43:21 GMT

Can a field extraction be devised so that it has a default value when the regex is not matched?

I have defined an extracted field based on a regex which matches a specific pattern in an event. The resulting field will contain the matched data if it was present and the field will not exist for an event where the pattern was not matched.

All that is good.

However, for the cases where the pattern did not match, I would rather the field exist and contain a hyphen ("-").

Within the confines of a field extraction, is there a way to do this? I know I could use fillnull to add the hyphens later, but I'd prefer a more elegant solution.

In no solution exists, I can live with it, but if I can have this, it would streamline my searching.

Thanks!

Re: Field extractions with default value

aholzer — Tue, 17 Dec 2013 20:58:06 GMT

You can simply use the command fillnull at search time to get what you want.

http://docs.splunk.com/Documentation/Splunk/6.0/SearchReference/fillnull

Like so:

| fillnull value="-"

Where needs to be the field that you want to add hyphens instead of not having the field.

Hope this helps

Re: Field extractions with default value

Ayn — Tue, 17 Dec 2013 21:08:36 GMT

I converted your comment into an answer - if it's an answer please put it in as one 🙂

Re: Field extractions with default value

aholzer — Tue, 17 Dec 2013 21:43:00 GMT

Fair enough @Ayn 🙂

Re: Field extractions with default value

ltruesda — Tue, 17 Dec 2013 21:51:38 GMT

As mentioned in my question I knew about this possibility. But I am hoping to have this populated at extraction time and simplify my searches.

Re: Field extractions with default value

LukeMurphey — Wed, 18 Dec 2013 06:37:20 GMT

You could use calculated fields if you want to avoid using searches to populate the value.

In this snippet from props.conf, bytes_out will always be populated to 0 if it was null:

[somesourcetype]
EVAL-bytes_out = if(isnull(bytes_out),0,bytes_out)

The normal eval functions should work. Note that calculated fields was included starting with Splunk 5.0 so it won't work on 4.X or earlier.

Re: Field extractions with default value

aholzer — Wed, 18 Dec 2013 14:09:42 GMT

Guess I should read peoples questions more carefully 🙂

Take a look at Luke's answer. Looks promising.

Re: Field extractions with default value

ltruesda — Thu, 19 Dec 2013 00:25:44 GMT

Thanks, just what the doctor ordered! 🙂