ATLINE()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return the line number of the first occurrence of a search string in a memo field or character string

Syntax

ATLINE(<expC1>,<memofield>|<expC2>)

See Also

AT(), AT_C(), ATC(), ATNEXT(), CHRTRAN(), CHRTRANC(), GETWORDCOUNT(), GETWORDNUM(), HTML_TOPLAINTEXT(), INLIST(), LEFT(), LEFTC(), LEN(), LENC(), MEMLINES(), MEMOREAD(), MEMOTRAN(), MEMOWRITE(), MLCOUNT(), MLINE(), OCCURS(), RAT_C(), RAT(), RIGHT(), RIGHTC(), SET MEMOWIDTH, SET STRESCAPE, STR(), STREXTRACT(), STRPOS(), STRTRAN(), STUFF(), STUFFC(), SUBSTR(), SUBSTRC()

Description

The ATLINE() function returns the line number of the first occurrence of the search string <expC1> in a memo field or character string (<expC2>).

Lines here are determined by the line termination character (chr(10)) and are not affected by SET MEMOWIDTH.

Example

open database southwind
use customers
nLine = atline("vacation",notes)