SUBSTRING_AFTER

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

Usage

SUBSTRING_AFTER(source, match)

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

String

SUBSTRING_AFTER(‘Hello everyone’, ‘ever’)	yone
SUBSTRING_AFTER(‘Hello everyone’, ‘sam’)	Hello everyone

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