Register
Sign In
The lastc function extracts a specified number of characters from the end (right) of a text value.
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.
TEXT VALUE
A string/text that we want to copy part of from the end.
n
Number. The length of the piece we want to cut of
Examples
Returns: Ease
Returns: EASE
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.
The lastc function extracts a specified number of characters from the end (right) of a text value.
Syntax
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
Returns: Ease
Returns: EASE
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.
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
