Difference between revisions of "LEN()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return length of specified expression | Function to return length of specified expression | ||
| − | |||
==Syntax== | ==Syntax== | ||
LEN(<exp>[,<expL>]) | LEN(<exp>[,<expL>]) | ||
| − | |||
==See Also== | ==See Also== | ||
[[AT()]], [[LEFT()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | [[AT()]], [[LEFT()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRLEN()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]] | ||
| − | |||
==Description== | ==Description== | ||
The LEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. When checking the length of character expressions, the optional <expL> can be specified. If <expL> is specified and evaluates to .T. (true), the LEN() function will return the length of the character expression after stripping any formatting options such as BOLD(). | The LEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. When checking the length of character expressions, the optional <expL> can be specified. If <expL> is specified and evaluates to .T. (true), the LEN() function will return the length of the character expression after stripping any formatting options such as BOLD(). | ||
| − | |||
==Example== | ==Example== | ||
| Line 32: | Line 28: | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 12:13, 7 December 2012
Contents
Purpose
Function to return length of specified expression
Syntax
LEN(<exp>[,<expL>])
See Also
AT(), LEFT(), RAT(), RIGHT(), SET STRESCAPE, STREXTRACT(), STRLEN(), STRTRAN(), STUFF(), SUBSTR()
Description
The LEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. When checking the length of character expressions, the optional <expL> can be specified. If <expL> is specified and evaluates to .T. (true), the LEN() function will return the length of the character expression after stripping any formatting options such as BOLD().
Example
open database southwind use example ? len(last_name) 16 ? len(notes) 8851 ? len("") 0 ? len(bold("Hello")) 9 ? len(bold("Hello"),.T.) 5
