RIGHT() : extract the last characters of a text

The RIGHT() function returns the last n characters of a string, as a text string. It comes in handy for extracting the end of a code or an identifier.

The output type format of the result is configured in the output field options of the formula editor: see Formula column.

Syntax

RIGHT(text, number_of_characters)

How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.

Parameters

# Parameter Description

1 text Source text string.

2 number_of_characters Number of characters to return from the end (1 by default).

Example

Extract the last 4 characters

"ABC1234" becomes "1234".

RIGHT("ABC1234", 4)

If number_of_characters is 0, an empty string is returned. If number_of_characters is greater than the length of the text, the full string is returned.

Go further

LEFT

Extract the first n characters of a text string.

Read more →

Or continue with

Formula glossary

All available operators and functions, organized by category.