REGEX help - capture supplier name

[Cardon_Cezar]

How to capture “THE GRAPE” from the below string. I think the easiest way is to say from the beginning of ROW until “MissionCritical” (which is a constant), but I don’t know how.

FACTURA FF0002
Data emiterii:  27/07/2020

Furnizor Client

THE GRAPE MissionCritical
CIF:  32574370 CIF:  123456

[Steven_McKeering]

Hello

Try this Regex pattern. It uses a ‘Positive Lookahead’.
.*(?=MissionCritical)

It will match any characters from the start of the string/line and stop at the words ‘Mission Control’.

It will be case sensitive.