Field and record

Field and record functions perform a variety of different tasks with the basic components that make up Analytics tables.

For example, you can test whether a field exists, find out the data type of a field, and capture record numbers. Field and record functions can perform useful helper tasks during data analysis in an Analytics script.

Function descriptions

Function	Description
FTYPE( )	Returns a character identifying the data category of a field or variable, or the type of an Analytics project item.
HASH( )	Returns a salted cryptographic hash value based on the input value.
ISDEFINED( )	Returns T (true) if the specified field or variable is defined, and F (false) otherwise.
OFFSET( )	Returns the value of a field with the starting position offset by a specified number of bytes.
RECLEN( )	Returns the length of the current record.
RECNO( )	Returns the current record number.
RECOFFSET( )	Returns a field value from a record that is a specified number of records from the current record.
VERIFY( )	Returns a logical value indicating whether the data in a physical data field is valid.

[ Back to top ]