I see.
You can probably get quite close through the use of PATINDEX and diligent use of wildcards. Have you tried this?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.