Returns the numeric position of the last occurrence of a character expression or memo field within another character expression or memo field.
RATC(cSearchExpression, cExpressionSearched [, nOccurrence]) |
Parameters
- cSearchExpression
- Specifies the character expression that RATC(В ) looks for in cExpressionSearched.
- cExpressionSearched
- Specifies the character expression that RATC(В ) searches. The character expressions cSearchExpression and cExpressionSearched can be memo fields of any size.
- nOccurrence
- Specifies which occurrence, starting from the right and moving left, of cSearchExpression RATC(В ) searches for in cExpressionSearched. By default, RATC(В ) searches for the last occurrence of cSearchExpression (nOccurrence equals 1). If nOccurrence is 2, RATC(В ) searches for the next to last occurrence, and so on.
Return Value
Numeric
Remarks
RATC(В ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, RATC(В ) is equivalent to RAT(В ).
RATC(В ) returns the numeric position of the last occurrence of a character expression or memo field within another character expression or memo field. The character expressions or memo fields can contain any combination of single-byte and double-byte characters.
RATC(В ) is the reverse of the AT_C(В ) function: it searches from right to left.
RATC(В ) returns an integer indicating the position of the first character in cSearchExpression in cExpressionSearched. RATC(В ) returns 0 if cSearchExpression isn't found in cExpressionSearched, or if nOccurrence is greater than the number of times cSearchExpression occurs in cExpressionSearched.
The search performed by RATC(В ) is case-sensitive.
This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.