FIRSTORNULL ER function
The FIRSTORNULL function returns the first record of the specified list as a Container (record) value, if that record isn't empty. If the record is empty, this function returns a null Container (record) value.
Syntax
FIRSTORNULL (list)
Arguments
list: Record list
The valid path of a data source of the Record list data type.
Return values
Container (record)
The resulting record value.
Example
The expression FIRSTORNULL(SPLIT("",1)).Value returns an empty string ("").