substring-before

Checks that a given string contains the characters of a second given string and returns the part of the first string that precedes the occurrence of the second string.

Syntax

    substring-before(string, string)

Parameters

Two string values separated by a comma. substring-before checks that the first string contains the second string.

Returns

A string that contains the characters from the first parameter that precede the occurrence of the second parameter in the first parameter. If the first parameter does not include the characters from the second parameter, substring-before returns an empty string.

Example

The following expression returns 2005:

substring-before("2005/04/01","/")

// Ethnio survey code removed