Community Connections Cambridge – SEO & Web

2016-11-30

Look for and number sequence 100 to 999 in a URL \b0*([1-9][0-9][0-9])\b To use it with a string \/position\/\b0*([1-9][0-9][0-9])\b

2016-08-16

Quite often if you open a CSV file in Excel with American date formats Excel will do its best to convert them (badly) and you end up with some in date...

2016-07-18

Find the Monday for a week that a date falls into =A2-(MOD(WEEKDAY(A2)-2,7)) Where A2 is the field with the date. The great thing is that It works...

2016-05-05

This is something I do regularly, wanting to look at log activity over a 30 minute range Use datediff and “mins” datepart like this (datediff(mins,...

2016-04-01

This should be easy url_domain || url_path || url_query_params  as request really should work. BUT if any one of these is null it will deliver a null...

2016-03-11

This is quite straight forward but seems to cause confusion on the internet Time to the nearest 10 minutes TO_CHAR(DATE,’HH’) || ‘:’ || trim(TO_CHAR...

2015-08-19

It is quite easy and very useful if you are running complex and long calculations. Add Excel to you Start Menu. – In the program files right click Excel...

2015-05-27

We all love Webpagetest.org To get the best quality images and video you can use this version of the URL http://www.webpagetest.org/?pngss=1&iq...

2015-03-04

This method is almost instant (using 500,000 record lookups) IF(M56=INDEX(‘Sitemap Keyword Categories’!$G$1:$G$300016,MATCH(M56,’Sitemap Keyword Categories...

2014-11-24

It may sound complicated but this is really useful and not that complex. If you are into web design and performance you will have Firebug loaded in Firefox...