AT()

Return the position of a substring within a character string.

Syntax

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

Arguments

<cSearch> --> is the character substring for which to search.

<cTarget> --> is the character string being searched.

Returns

AT() returns the position of the first occurrence of a character within any given string. It requires the character to be sought <cSearch> and the string in which the character can be found <cTarget>. If not found AT() returns 0.

Description

AT() is a character function used to determine the position of the first occurrence of a character substring within another string. To find the last instance of a substring within a string, us RAT().

____________________________