Difference between revisions of "STRLEN()"

From Lianjapedia
Jump to: navigation, search
(Products)
 
(2 intermediate revisions by the same user not shown)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[AT()]], [[LEFT()]], [[LEN()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
+
[[AT()]], [[LEFT()]], [[LEN()]], [[LENC()]], [[RAT()]], [[RIGHT()]], [[SET STRESCAPE]], [[STR_COMPRESS()]], [[STR_UNCOMPRESS()]], [[STREXTRACT()]], [[STRTRAN()]], [[STUFF()]], [[SUBSTR()]]
  
 
==Description==
 
==Description==
The STRLEN() 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 STRLEN() function will return the length of the character expression after stripping any formatting options such as BOLD().
+
The STRLEN() function returns the output width of the specified expression <exp>.  The expression can be of any data type, including memo fields and arrays.  The optional <expL> is ignored.
  
 
==Example==
 
==Example==
Line 21: Line 21:
 
? strlen("")
 
? strlen("")
 
         0
 
         0
? strlen(bold("Hello"))
 
        9
 
? strlen(bold("Hello"),.T.)
 
        5
 
 
</code>
 
</code>
  
==Products==
+
 
Lianja Server, Lianja
+
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data Functions]]

Latest revision as of 12:45, 22 March 2021

Purpose

Function to return length of specified expression

Syntax

STRLEN(<exp>[,<expL>])

See Also

AT(), LEFT(), LEN(), LENC(), RAT(), RIGHT(), SET STRESCAPE, STR_COMPRESS(), STR_UNCOMPRESS(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The STRLEN() function returns the output width of the specified expression <exp>. The expression can be of any data type, including memo fields and arrays. The optional <expL> is ignored.

Example

open database southwind
use example
? strlen(last_name)
        16
? strlen(notes)
      8851
? strlen("")
         0