Function StartsWith() & Ends with()

Tips and Tricks

Determines if a value starts or ends with a particular value or reference. The functions resolve to 1 or 0, i.e. true or false.

Usage:

StartsWith( o, f)

EndsWith( o, f)

Parameters:

o Original value, or question reference.
f Value to find within the original value or reference.

Example:

The examples below returns true if the ‘Region’ data field starts with ‘22’.

 StartsWith([Q1.Region], "22")

Related Articles

Keywords

begins finishes contains beginswith