ATCC( ) Function

  • Article

Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, without regard for the case of these two expressions.

ATCC(cSearchExpression, cExpressionSearched [, nOccurrence])

Return Values

Numeric

Parameters

  • cSearchExpression
    Specifies the character expression that ATCC( ) searches for in cExpressionSearched.

  • cExpressionSearched
    Specifies the character expression cSearchExpression searches for.

    Both cSearchExpression and cExpressionSearched can be memo fields of any size.

  • nOccurrence
    Specifies which occurrence (first, second, third, and so on) of cSearchExpression is searched for in cExpressionSearched. By default, ATCC( ) searches for the first occurrence of cSearchExpression (nOccurrence = 1). Including nOccurrence lets you search for additional occurrences of cSearchExpression in cExpressionSearched.

Remarks

ATCC( ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, ATCC( ) is equivalent to ATC( ).

ATCC( ) searches the second character expression for the occurrence of the first character expression, without concern for the case (upper or lower) of the characters in either expression. Use AT_C( ) to perform a case-sensitive search.

ATCC( ) returns an integer corresponding to the position where the first character of the character expression is found. If the character expression isn't found, ATCC( ) returns 0.

This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.

See Also

AT( ) | AT_C( ) | ATC( ) | ATCLINE( ) | ATLINE( ) | LEFT( ) | RAT( ) | RATLINE( ) | RIGHT( ) | SUBSTR( ) | LEFTC( ) | RIGHTC( ) | SUBSTRC( )