SUBSTRING_BEFORE

Returns the substring of the provided string before the match of the string to match (see Remarks).

Usage

SUBSTRING_BEFORE(source, match)

source	String	The string to get a substring of.
match	String	The string to match.

String

SUBSTRING_BEFORE(‘Hello everyone’, ‘ever’)	Hello
SUBSTRING_BEFORE(‘Hello everyone’, ‘joe’)	Hello everyone

If there’s no match in the source, the function returns the original string.