I have column H that contains long GET requests on sheet 1 such as:

H
GET /profiles/text/23493495_3492/g93id93kd
GET /edit/result/393493/te3903k4d

I would like to have a second sheet with the following type of list in columns A and B:

A B
23493495 identifier1
3903k4 realid2
g93id realid3

Ultimately, I would like a function that will search sheet 1 column H for any of the values in sheet 2 column A. Most of the time there is no separator so I need it to search for strings within the GET string. Once a value in sheet 2 column A is matched with a value in sheet 1 column H, I would like the function to take the corresponding text in sheet 2 column B and print it in sheet 1 column I. There may be multiple matches in a cell, so that would need to be taken into account. So if using the example above:

In H1, there would be a match of 23493495 and g93id within the string. I would like sheet 1 column I to display:

I
identifier1, realid3

or

I J
identifier1 realid3

I have tried quite a few things. I know that the below code will match an exact hit but not within a string (with no separator) and won't display multiple matches. Any help is appreciated.

=VLOOKUP(H2,identifiers!A:B,2,FALSE)