The LeftPart function finds the first occurence of any sub-string (SubStr parameter) in specified string (Str parameter) and returns the part of string (SubStr) AFTER the separator (Str). If the SubStr can not be found in the Str, the function returns empty string.

If you would like to find LAST occurence of sub-string in specified string  use RightPartR function.