Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

TEXTAFTER Function

The TEXTAFTER function is one of the text and data functions. It is used to return text occurring after delimiting characters.

Syntax

TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

The TEXTAFTER function has the following argument:

Argument Description
text The text the search is conducted within. Wildcard characters are not allowed. If text is an empty string, the function returns empty text.
delimiter The text that marks the point after which the function extracts the text.
instance_num An optional argument. The instance of the delimiter after which the function extracts the text. By default, instance_num equals 1. A negative number will start the text search from the end.
match_mode An optional argument. It is used to determine whether the text search is case-sensitive. The default is case-sensitive. The following values are used: 0 for case sensitive, 1 for case insensitive.
match_end An optional argument. It treats the end of text as a delimiter. By default, the text is an exact match. The following values are used: 0 for not matching the delimiter against the end of the text, 1 for matching the delimiter against the end of the text.
if_not_found An optional argument. It sets a value that is returned if no match is found.

Notes

How to apply the TEXTAFTER function.

Examples

The figure below displays the result returned by the TEXTAFTER function.

TEXTAFTER Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action