, , ,

WORDS_FROM_LEFT

Description

Returns the text being the specified number of the leftmost words in the provided text. <callout type=“primary” title=“note” icon=“true”>Cloudscape/Derby database only.</callout>

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

Example

IF WORDS_FROM_LEFT (Account.Name, 1) = 'John' THEN ...