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 non-blank 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.