Custom Formula - 2 part question

Custom Formula - 2 part question

Genuitywww.genuity.com/Mobile/Pages/home.aspx#SubItemAnchor18-1?utm_source=Weather_FarmersForecast&utm_medium=TextMessaging&utm_content=140CHAR_ProductAnnouncement_VT2PRORIB&utm_campaign=Genuity_Mobile http://bit.ly/sdkqVwCustomizeCopy

I have two tables where I need to extract everything after the last / in the url but before the CustomizeCopy text.  I am not sure how to write this in SQL.

The second part is that I will have two tables with this same formula, leaving me with a column in each table that is identical.  Then I want to join some data from those two tables together.  For some reason, each time I try to do this, my two columns I'm joining onto the first table from the second have no data or information in them.  Additionally, the other columns have the text shortened significantly from the original table.

Any help you can offer would be greatly appreciated.

Thanks.