The general pattern if you want something between xx and yy is:
(?<=xx).+?(?=yy)
Just replace xx with what’s in front what you want to capture and yy with what’s behind.
E.g. applying the pattern
(?<=John ).+?(?= Doe)
on the text “John Hamilton Doe” will give you “Hamilton”.
See this post to learn more about regex: