Difference between revisions of "ATLINE()"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==Purpose== | ==Purpose== | ||
| − | Function to | + | Function to return the line number of the first occurrence of a search string in a memo field or character string |
==Syntax== | ==Syntax== | ||
| − | ATLINE(< | + | ATLINE(<expC1>,<memofield>|<expC2>) |
==See Also== | ==See Also== | ||
| − | [[AT()]], [[AT_C()]], [[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()]] | + | [[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== | ==Description== | ||
| − | The ATLINE() function | + | 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== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | open database southwind | |
| + | use customers | ||
| + | nLine = atline("vacation",notes) | ||
</code> | </code> | ||
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)
