I downloaded the CSV file and then ran some queries on it. A poor mans way of doing it would be to open the CSV file in a text editor like UltraEdit and do searches for specific strings (e.g. .EDU/ ) and use the counting option of the search feature to count the number of instances.
In my case I imported the file into Microsoft Access and then ran some queries. The following query allowed me to see how many links I got for different ccTLDs (it assumes that I imported the link data into a table called "tblExternalLinks":
Code:
SELECT IIf([Links] Like "*.[a-z][a-z]/*",Mid([Links],InStr(10,[Links],"/")-2,2)) AS CountryCode, Count(tblExternalLinks.Links) AS CountOfLinks
FROM tblExternalLinks
WHERE (((tblExternalLinks.Links) Like "*.[a-z][a-z]/*"))
GROUP BY IIf([Links] Like "*.[a-z][a-z]/*",Mid([Links],InStr(10,[Links],"/")-2,2))
ORDER BY Count(tblExternalLinks.Links) DESC;
In Access that query could be quickly modified to search for other results like the following query to find EDU sites under specific ccTLDs:
Code:
SELECT IIf([Links] Like "*.[a-z][a-z]/*",Mid([Links],InStr(10,[Links],"/")-2,2)) AS CountryCode, Count(tblExternalLinks.Links) AS CountOfLinks
FROM tblExternalLinks
WHERE (((tblExternalLinks.Links) Like "*.edu.[a-z][a-z]/*"))
GROUP BY IIf([Links] Like "*.[a-z][a-z]/*",Mid([Links],InStr(10,[Links],"/")-2,2))
ORDER BY Count(tblExternalLinks.Links) DESC;
Bookmarks