ABSENT

The ABSENT function tests for the absence of an object.

Syntax:
ABSENT (single-object-expression)
Meaning:
ABSENT (object_to_test)
Returns:
True or false

ABSENT returns "true" if the object_to_test evaluates to "none". If the object_to_test does not evaluate to "none", the function returns "false".

Examples

  • You can use this function to map an object only if another object is absent. For example, you might want to map BillTo information to the ShipTo fields if the ShipToName is absent.
  • ABSENT (AreaCode:Phone)

    This example evaluates to "true" when AreaCode:Phone evaluates to "none" or evaluates to "false" when AreaCode:Phone does not evaluate to "none".

Related Functions

  • PRESENT