URL and text percentage

Im currently trying to find the relevance percentage of URL and the page title.

Example: URL: mysite*dot*com/Understanding-URL-Parameters/index.html
Page title: Technical Guide: URL Parameters

Im looking for something that will be able to check the path after mysite*dot*com and return a percentage match of the path and the page title.

Understanding-URL-Parameters : Technical Guide: URL Parameters (60%)

After research ive found similar scripts but none fit my situation as they would get character percentage and word percentage, the word would fit perfectly but the percentage would take into account the mysite*dot*com and the dash (-) in the URL would cause the script to return inaccurate results.

Hello dflak,

Thanks for the script, how do you import the url and title from a cell?
i looked into it, but i couldnt make it through. Im not familiar with vb.

Originally Posted by dflak

In this code, I did not import the data; I actually passed hard-coded strings. I'm sorry if I threw you off by having the URL and Title also on the spreadsheet. Originally I did intend to import it.

The syntax for reading data form a cell is relatively simple. In general:

Please Login or Register  to view this content.

For example

Please Login or Register  to view this content.

However, GetPercent is a function. You can call it from Excel directly. If the URL is in B2 and the Title is in B3 than =GetPercent(B2,B3) will get you the percent.

You are correct i missed that using the function directly from the cell is much easier thanks.

For some reason it works with my given example but whenever i try a different domain it always returns 0.
The example works correctly on cell and on msgbox anything else wont, tried removing www or http but nothing.

Im trying to match the whole path after .com so on every URL it would be different.

sorry if i didn't made that clear!