How to select part of the text according to the template in Google sheets?

Question

Google Sheets

I have a column with the following cells:
"Romashka Business Center | Offices for rent"
"Buttercup Business Center | Offices for rent"
"Motylok Business Center | Offices for rent"
I need to get the names. Those. extract the text after "center" and before "| Rent".
Of the suitable ones, I found the SPLIT and REGEXEXTRACT functions. But so far I haven't been able to use them.
Can you tell me how to write formulas correctly?

Answer 1

REGEXEXTRACT is just what you need, all that's left is to write a simple regular expression:
" ([а-яА-Я]+) \|"
Example

Answer 2

=REGEXEXTRACT(A1;"([А-Яа-яёЁ]+)\s*\|")