I want to grab a value from my bottom sheet via a key index number.

I got a sheet with an index number like “19/4116”

Then I got my bottom sheet where the index number is “hidden” among other information in one field. Like this:

BR-Drs. 379/18 (Gesetzentwurf) BT-Drs. 19/4116 (Gesetzentwurf) BT-Drs. 19/4569 (Beschlussempfehlung und Bericht)

At the moment my way to solve it, is to split the column on the whitespaces.

In this sheet I know it must be the new 2. column or the new 5. column to look for a match. (“379/18” or “19/4116”)

Is there a more elegant way to do this?

Replace with RegEx maybe? The index number is consistent with 19/…

But since there multiple index numbers like this in one field I don´t see how to get there.

Any ideas?