TEXT_AFTER Function

Parameters (String, String);

Returns: STRING

Function to return all characters following the last instance of the search string.

The first parameter is the source string.

The second parameter is search string.

If the first parameter is NULL, NULL is returned.

If the second parameter is NULL, the first parameter is returned.

Example: TEXT_AFTER(‘C:\Users\Tony’,'\') = ‘Tony'

Example: TEXT_AFTER('Hamburger','m') = ‘burger'

Example: TEXT_AFTER('Hamburger','i') = 'Hamburger'