Specifications

LeftTrim
698 InfoMaker
LeftTrim
Description Removes spaces from the beginning of a string.
Syntax LeftTrim ( string )
Return value
String. Returns a copy of string with leading spaces deleted if it succeeds and
the empty string (“”) if an error occurs.
Examples This expression returns RUTH:
LeftTrim(" RUTH")
This expression for a computed field deletes any leading blanks from the value
in the column lname and returns the value preceded by the salutation specified
in salut_emp:
salut_emp + " " + LeftTrim(lname)
See also RightTrim
Trim
Len
Description Reports the length of a string in characters.
Syntax Len ( string )
Return value Long. Returns a long containing the length of string in characters if it succeeds
and –1 if an error occurs.
Examples This expression returns 0:
Len("")
This validation rule tests that the value the user entered is fewer than 20
characters:
Len(GetText()) < 20
See also
LenA
Argument Description
string The string you want returned with leading spaces deleted
Argument Description
string The string for which you want the length