What is the syntax to return a substring?

To return a substring that does not start with the beginning of the string: click me
To return a substring that starts with the beginning of the string: click me
To return a substring that does not start with the beginning of the string: click me

Advertisements

What is the syntax to remove spaces from beginning/end of string?

‘Method 1
Trim(<string variable>)

‘Method 2
LTrim(<string variable>)
RTrim(<string variable copy after left trim>)