https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219241#M64443 <P>I'm looking through some old searches and came across this line. From all the documentation I've found, coalesce returns the first non-null field. In this case, what is the '0' representing? If randomField is null, does it just return a char 0?</P> Thu, 25 Feb 2016 19:00:38 GMT ryanfarley8189 2016-02-25T19:00:38Z https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219241#M64443 <P>I'm looking through some old searches and came across this line. From all the documentation I've found, coalesce returns the first non-null field. In this case, what is the '0' representing? If randomField is null, does it just return a char 0?</P> Thu, 25 Feb 2016 19:00:38 GMT https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219241#M64443 ryanfarley8189 2016-02-25T19:00:38Z https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219242#M64444 <P>Null is the absence of a value, 0 is the number zero. <CODE>coalesce(field, 0)</CODE> returns the value of the field, or the number zero if the field is not set.</P> Thu, 25 Feb 2016 19:22:10 GMT https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219242#M64444 martin_mueller 2016-02-25T19:22:10Z https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219243#M64445 <P>Great. Thanks!</P> Thu, 25 Feb 2016 19:26:37 GMT https://community.splunk.com/t5/Splunk-Search/What-does-coalesce-randomField-0-do/m-p/219243#M64445 ryanfarley8189 2016-02-25T19:26:37Z