[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
RAT()
Return the position of the last occurrence of a substring
------------------------------------------------------------------------------
Syntax
RAT(<cSearch>, <cTarget>) --> nPosition
Arguments
<cSearch> is the character string to locate.
<cTarget> is the character string to search.
Returns
RAT() returns the position of <cSearch> within <cTarget> as an integer
numeric value. 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. 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.
Examples
. This example uses RAT() to create a user-defined function,
FilePath(), that extracts the path from a file specification. If the
path is unspecified, FilePath() returns a null string (""):
? FilePath("C:\DBF\Sales.dbf") // Result: C:\DBF\
FUNCTION FilePath( cFile )
LOCAL nPos, cFilePath
IF (nPos := RAT("\", cFile)) != 0
cFilePath = SUBSTR(cFile, 1, nPos)
ELSE
cFilePath = ""
ENDIF
RETURN cFilePath
Files: Library is EXTEND.LIB.
See Also:
AT()
LEFT()
RIGHT()
STRTRAN()
SUBSTR()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson