RIGHT Function

Description: Returns a string containing the specified number of characters, starting from the right 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: RIGHT (<source text>,<character count>)

Example: Set the value in String 1 right to the rightmost five characters from String 1.

DE("String 1 right").setValue
  (RIGHT( DE("String 1").getValue( ), 5 ));

{{export-indexterm primary="RIGHT function"/}}

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*