AT_C( ) 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, counting from the leftmost character.

AT_C(cSearchExpression, cExpressionSearched [, nOccurrence])

Return Values

Numeric

Parameters

  • cSearchExpression
    Specifies the character expression that AT_C( ) 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, AT_C( ) searches for the first occurrence of cSearchExpression (nOccurrence = 1). Including nOccurrence lets you search for additional occurrences of cSearchExpression in cExpressionSearched. AT_C( ) returns 0 if nOccurrence is greater than the number of times cSearchExpression occurs in cExpressionSearched.

Remarks

AT_C( ) searches the second character expression for the first occurrence of the first character expression. It then returns an integer indicating the position of the first character in the character expression found. If the character expression isn't found, AT_C( ) returns 0.

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

The search performed by AT_C( ) is case-sensitive. To perform a search that isn't case-sensitive, use ATCC( ).

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

See Also

ATCC( ) | AT( ) | ATC( ) | ATCLINE( ) | ATLINE( ) | LEFT( ) | RAT( ) | RATLINE( ) | RIGHT( ) | SUBSTR( ) | ATCC( ) | LEFTC( ) | RIGHTC( ) | SUBSTRC( ) | $ Operator | OCCURS( ) | INLIST( )