ExtractAny$

Takes two parameters, Source , Search 

Description:

Similar to Extract$, ExtractAny$ will search the source value for any exact match of the search value. If a match is found, this function will return the original source value up to, but not including the search value.

Example:

ExtractAny$ "John Doe", " "

returns "John"