Splunk Search

Quick Question: eval

Path Finder

I have a chart:

Los Angeles   New York   Boston   Washington D.C.   Total
5             3                   2                 10

and

... | eval "x"='New York'+'Washington D.C'

returns x=5. However,

... | eval "x"='New York'+'Boston'+'Washington D.C'

returns an empty value, i.e. x=

How do I get around this problem where 'Boston' is empty?

Thank you.

Tags (1)
0 Karma
1 Solution

Splunk Employee
Splunk Employee

use the ifisnull() or coalesce() function:

... | eval "x"=coalesce('New York',0)+coalesce('Boston',0)+ifisnull('Washington D.C',0,'Washington D.C')

Or you could use the | fillnull search command.

View solution in original post

Splunk Employee
Splunk Employee

use the ifisnull() or coalesce() function:

... | eval "x"=coalesce('New York',0)+coalesce('Boston',0)+ifisnull('Washington D.C',0,'Washington D.C')

Or you could use the | fillnull search command.

View solution in original post

Splunk Employee
Splunk Employee

I had

... | fillnull value=0 'Los Angeles' 'New York' 'Boston' 'Washington D.C.' | eval x='New York'+'Boston'+'Washington D.C'

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!