Challenge to find exact text string match

In the four rows of text below I'm trying to match each gas stick to its corresponding gasline.

I think I can count over to "GAS STICK" and get the number. <15>
From that point I can count over to "," (comma) and get that number. <26>
So the gas stick will be between the first number and one less than the second number. <GAS STICK 1>

I need help completing this code to place a the line or stick number in a cell B of the same row.
Column A would have the description and column B of the same row would either be "1" or "11" respectively.
Column C would be the shortened description (GAS STICK 1).


1] "HUNGA, DUNGA, GAS STICK 1, THINGY"
2] "DOHICKY, GAS STICK 11, THINGUS"
3] "SCAPPEN, DAPPER, GASLINE 1"
4] "SUCH, AND, SUCH, GASLINE 11"

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Heres another..

Please Login or Register  to view this content.