Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 697
Examples This expression returns BABE:
Left("BABE RUTH", 4)
This expression returns BABE RUTH:
Left("BABE RUTH", 40)
This expression for a computed field returns the first 40 characters of the text
in the column home_address:
Left(home_address, 40)
See also
LeftA
Mid
Pos
Right
LeftA
Description Obtains a specified number of bytes from the beginning of a string.
Syntax LeftA ( string, n )
Return value
String. Returns the characters in the leftmost n bytes in string if it succeeds and
the empty string (“”) if an error occurs.
If n is greater than or equal to the length of the string,
LeftA returns the entire
string. It does not add spaces to make the return value’s length equal to n.
Usage LeftA replaces the functionality that Left had in DBCS environments in
InfoMaker 9. In SBCS environments,
Left and LeftA return the same results.
See also MidA
PosA
RightA
Argument Description
string The string containing the characters you want
n A long specifying the number of bytes you want