nvl()

Description:

Get the first non-null member that isn’t double quoted from an integer sequence.

Syntax:

A.nvl()

Equivalent to nvl(x1,…,xn)

Note:

The function gets the first non-null member that isn’t double quoted from integer sequence A.

Parameters:

A

An integer sequence

Return value:

A non-null an non-double-quoted member

Example:

 

A

 

1

=[1,2,4].nvl()

1

2

=[null,2,3,4].nvl()

2

3

=["",2,3,4].nvl()

2