Need to search a field for s string and return all values up to a delimiter and then split the field to continue searching

See more:

string

T-SQL

Hi,

I have the following challenge. I need to search field for a specific string of text.
Then return all of the characters up to a delimiter.

This is an example of a row of data in the field. GENETABLE.GeneField

Gene ID=ABA2 SIS4 GIN1 SDR1 ISI4 SRE1 ATABA2 ATSDR1_AT1G52340 | Genotype_Zygosity=homozygous diploid _APO:0000229 | Mutant LOF_GOF ID=loss of function_APO:0000011 && Gene ID=CESA8 IRX1 ATCESA8 LEW2_AT4G18780 | Genotype_Zygosity=homozygous diploid _APO:0000229 | Mutant LOF_GOF ID=loss of function_APO:0000011

So I the specific string needed is 'Gene ID='

Then I would return one row:
Gene ID=ABA2 SIS4 GIN1 SDR1 ISI4 SRE1 ATABA2 ATSDR1_AT1G52340 |
It would find the next gene id and return another row
Gene ID=CESA8 IRX1 ATCESA8 LEW2_AT4G18780 |

So it would split out this field into 2 rows.

Desired output
Gene ID=ABA2 SIS4 GIN1 SDR1 ISI4 SRE1 ATABA2 ATSDR1_AT1G52340 |
Gene ID=CESA8 IRX1 ATCESA8 LEW2_AT4G18780 |

After this it it would move to the next row of the GENETABLE

Any help would be greatly appreciated!

Thanks