Table of Contents

, ,

WORDS_FROM_RIGHT

Description

Returns the text being the specified number of the rightmost words in the provided text.

Syntax

WORDS_FROM_RIGHT (text, count)

Cannot be used in the condition of a FIND action.

Parameters

Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve

Returns

Text: the given number of rightmost words of the text (Cloudscape/Derby database only).

Example

IF WORDS_FROM_RIGHT (Account.Name, 1) = 'Smith' THEN ... 

WORDS_FROM_LEFT, WORD_NUMBER, CHARS_FROM_RIGHT