LEFT Function

Description: Returns a string containing the specified number of characters, starting from the left side of the source string.

Parameters: String, Integer

• Source text: The string containing the source value.
• Character count: The number of characters to be returned.

Return: String containing the number of characters requested. If the source string is shorter than the count specified, the entire source value is returned. If the source value is null, a null value is returned.

Syntax: LEFT (<source text>,<character count>)

Example: Set the value of String 7 left to the value of the first 5 characters from String 7.

DE("String 7 left").setValue
  ( LEFT( DE("String 7").getValue( ), 5 ));