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.