Edit

FIRSTORNULL ER function

  • Article

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 ("").

Additional resources

List functions