lastc

Type

Text Function

Purpose

The lastc function extracts a specified number of characters from the end (right) of a text value.

Syntax

lastc( TEXT VALUE, n)

Returns

A text value n characters in length.

Usage

lastc(FIELDNAME, 1) returns the last character in the field. Trailing spaces are ignored. If there are n or fewer characters in the field, lastc returns the original text value.

Examples

lastc( "DataEase" , 4)

Returns: Ease

lastc( "Club ParaDEASE" , 4)

Returns: EASE

lastc( FIRST NAME, 4)

Returns:The last four characters in the FIRST NAME field for every record that is processed. If the FIRST NAME field contains the value Roger, the function returns oger.