Extract and remove Row data when it contains specific string

[geeklarokcmie]

I'm looking to extract 100,000 + rows of data when it contains specific text.

for this example that specific text is Left|Match|Group..... - if the rows contain that specific text anything before that must be extracted.

Input:

Debit|or|=|C|AND|Reference|4|=|D33|Credit|Reference|4|=|064|Left|Match|Group|Right|Match|Group|Tolerance|Tolerance|effectiveDate|Left|Item|Additional|Op|Right|Item|Additional|Tolerance|Info|(L)|Info|(R)|Effective|DateYYYYMMDD|>=|Effective

Transaction|=|DW|AND|Transaction|=|GL|AND|Type|Type|Reference|9|<>|Reference|1|<>|AND|(|Reference|4|=|057|OR|Reference|4|=|043|)|Left|Match|Group|Right|Match|Group|Tolerance|Tolerance|effectiveDate|effectiveDate|Left

Output:

Debit|or|=|C|AND|Reference|4|=|D33|Credit|Reference|4|=|064

Transaction|=|DW|AND|Transaction|=|GL|AND|Type|Type|Reference|9|<>|Reference|1|<>|AND|(|Reference|4|=|057|OR|Reference|4|=|043|)

[AGilbert · Accepted solution]

try this regex as a starting point. You have to escape the 'or' meaning of the pipe character with a backslash to match it explicitly. 

[geeklarokcmie]

@AGilbert That worked perfectly. Thank you