RAT()

Return the position of the last occurrence of a substring. (A set of characters within a string.)

Syntax

RAT(<cSearch>, <cTarget>) --> nPosition

Arguments

<cSearch> --> is the character string (substring) to locate/match.

<cTarget> --> is the full character string that is being search.

Returns

RAT() returns the position of <cSearch> within <cTarget> as a number. If <cSearch> is not found, RAT() returns zero.

Description

RAT() is a character function that returns the position of the last occurrence of a character substring within another character string. It does this by searching the target string from the right. RAT() is like the AT() function which returns the position of the first occurrence of a substring within another string. (It scans starting from the left.) RAT() is also like the $ operator which determines whether a substring is contained within a string.

Both the RAT() and AT() functions are used with SubStr(), Left(), and Right() to extract substrings.

____________________________