Function Left(), Right(), and Substring()

Left(), Right(), and Substring() return a portion of a larger text string, used primarily for manipulating data that is received in an unusable format.

Usage

left(o, v) right(o, v) substring(o,s,v)

Parameters

o Original value, or question reference.
s A numeric value representing the character position where the sub-string begins. A value of 1 indicates the first value in the text.
v A numeric value representing the character position where the sub-string ends. 

Example

right([q1.ClientID], 6) substring([q1.ClientID],4,6)
 

Related Articles

 
substring string format