My goal is to turn the string http://google.com into “http://google.com/*” for over 800 different domains, which is way too many to do manually. There are several ways to manipulate strings in excel using the CONCATENATE function, which is well described in this tech republic article, but I will share the […]
Excel
Amazon S3 Log Analysis Made Simple With Excel
It wasn’t straightforward finding an easy way to analyze my Amazon S3 logs. I unsuccessfully tried several instructions and services before arriving at the simple solution below. I looked into paid services like S3Log, S3STAT, and Qloudstat. I tried the free version of Qloudstat, until my logs quickly exceeded the “free” limit, […]