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.


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


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. 


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

Related Articles

substring string format