RIGHT (PQL - xl)

This function returns the specified rightmost characters from a text value, and based on the number of characters you specify

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

RIGHT(text, OPTIONAL num chars)

Function Arguments

Name

Description

Type

Optional

text

Text string from which you want to return characters

String

num chars

Number of characters to return; if omitted, calculation uses one (1); if not an integer, the number is truncated

Number

Y

Comments

This function is the same as the Microsoft Excel 'RIGHT' function - using the same inputs, logic and outputs.