Difference between revisions of "ATLINE()"
Yvonne.milne (Talk | contribs) (Created page with "''Under Construction''") |
Yvonne.milne (Talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ==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()|chr(10)]]) and are not affected by [[SET MEMOWIDTH]]. | ||
| + | |||
| + | ==Example== | ||
| + | <code lang="recital"> | ||
| + | open database southwind | ||
| + | use customers | ||
| + | nLine = atline("vacation",notes) | ||
| + | </code> | ||
| + | |||
| + | [[Category:Documentation]] | ||
| + | [[Category:Functions]] | ||
| + | [[Category:Memos Functions]] | ||
| + | [[Category:String Data Functions]] | ||
| + | [[Category:Lianja v5.4]] | ||
Latest revision as of 06:09, 29 September 2020
Contents
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)
