FIELD( )

Topic group Related topics Example

Returns the name of the field in a specified position of a table.

Syntax

FIELD(<field number expN> [, <alias>])

<field number expN>

The position of the field whose name you want returned. The first field in a table is field number 1.

<alias>

The work area to check.

Description

FIELD( ) returns the name of a field in a table based on the specified <field number expN> parameter. The example shows a function that performs the reverse operation, returning the field number for a specified field name.

If the field name has spaces, FIELD( ) returns the name enclosed in colons, for example:

:Primary power coupling:

FIELD( ) returns an empty string ("") if the table does not contain a field in the specified position.

OODML

Check the fieldName property of the Field object.