Splitting by Delimiter - If Delimiter isn't present then skip to next one

[RhysWhite]

I hope somebody can help me quickly,

I have eMail data coming into Excel via Power Automate and I need to extract a reference number from either the Subject Or Body of the eMail.

Most of the references are preceded by certain words such as Reference or Number.

The solution I have come up with is to use Split Column By Delimiter - how do I search for multiple delimiters if the last one wasn't present?

Is this correct?  This is the base 
= Table.SplitColumn(Table.TransformColumnTypes(#"Changed Type", {{"Subject", type text}}, "en-GB"), "Subject", Splitter.SplitTextByAnyDelimiter({"Number"}, QuoteStyle.Csv, true), {"Subject.1", "Subject.2"})

If I modify it like this with multiple conditions it still seems to miss some.
= Table.SplitColumn(Table.TransformColumnTypes(#"Changed Type", {{"Subject", type text}}, "en-GB"), "Subject", Splitter.SplitTextByAnyDelimiter({"Number", "Reference", "no."}, QuoteStyle.Csv, true), {"Subject.1", "Subject.2"})

[RhysWhite · Accepted solution]

I've noticed I've put this in the wrong area, it should be in Power Queries.

Moving & Reposting now.

[amitchandak]

@RhysWhite ,
Can you please share sample data and sample output in table format?

I think you need to do two or more splits OR use Text.Contains and then do it

[RhysWhite]

@amitchandak Thanks - I can't share data - our policies make it very difficult to share anything externally.

Thanks Anyway