====== Coalesce(value1, value2…) ====== Category: Special function \\ =====Description===== This function returns the first value in the argument list that is //not// an [[syntax:types#empty_values|empty value]]. \\ =====Alternate formats===== This function can take from 2 to 6 values as arguments. coalesce(value1, value2, value3, value4, value5, value6) \\ =====Arguments===== ^Argument^Type^Description^ |valueN|Any|A value tested to determine whether it represents an //empty value// or not.| **Return value type:** Any (The type of the returned, non-empty value.) \\ =====Remarks===== To use the function with more than 6 arguments, nest function calls. Keep in mind that arguments are evaluated before a function is evaluated. If all arguments are empty values, an empty value is returned. \\ =====Examples===== coalesce(empty(), 'ABC', '') //Returns 'ABC' coalesce(empty(), '', 'ABC') //Returns '' (Empty text value but not an empty value.) coalesce(empty(),empty()) //Returns an empty value (All arguments are empty values.) coalesce(empty(), coalesce('ABC',empty()) ,'XYZ') //Returns 'ABC' (Nested functions) \\ =====See also===== * [[syntax:functions:empty|Empty()]] * [[syntax:functions:pick|Pick(index, values, separator)]]