Miscellaneous utilities

GETNTHPOPULATEDPARAM – Get nth non-empty parameter

93 views June 1, 2018 admin 0

Overview

Given any number of parameters, this Custom Field returns the nth non-empty parameter (starting from zero).

Syntax

GETNTHPOPULATEDPARAM(n,Parameter1, Parameter2, Parameter3)

GETNTHPOPULATEDPARAM(0,FIELDSTR(‘Small_Price’),FIELDSTR(‘Medium_Price’),FIELDSTR(‘Large_Price’))

n A numeral specifying the nth non-empty parameter to be displayed.
List The list of parameters from which the nth non-empty parameter will be displayed.

Examples

GETNTHPOPULATEDPARAM(0,‘apple’,”,’banana’,’pear’,”,’orange’) will return apple.

GETNTHPOPULATEDPARAM(1,‘apple’,”,’banana’,’pear’,”,’orange’) will return banana.

GETNTHPOPULATEDPARAM(0,”,’Jim’,’Fred’,”, ‘Julie’,”,’Paula’) will return Jim.

GETNTHPOPULATEDPARAM(3,”,‘Jim’,’Fred’,”, ‘Julie’,”,’Paula’) will return Julie.

See also

FIELDSTR

Was this helpful?