Assuming that cell B2 has a hostname like foo.bar.baz.example.com the following will extract just the domain name form the hostname, e.g. “example.com” =CONCATENATE(RIGHT(LEFT(B2,LEN(B2)-4),LEN(LEFT(B2,LEN(B2)-4))-FIND("|",SUBSTITUTE(LEFT(B2,LEN(B2)-4),".","|",LEN(LEFT(B2,LEN(B2)-4))-LEN(SUBSTITUTE(LEFT(B2,LEN(B2)-4),".",""))))),RIGHT(B2,4)) Of course this doesn’t work if you really care about supporting all the TLDs in the world but seriously, why was that so hard Excel? The same thing (with the same TLD [...]
Encrypting your data on Amazon EC2
November 26th, 2011 § 10 comments § permalink
Making sure your data is encrypted when it’s being stored somewhere outside of your direct control is a good idea. When that system has your customers data on it, it’s a requirement. Unfortunately when your data is in a cloud environment like Amazon EC2 your options can be limited, confusing, or both. Questions like where [...]
The Comedy and Tragedy of Automated Security Source Code Analysis – Act III
November 5th, 2010 § 0 comments § permalink
ACT III: Reality Sinks In (Read Act I & Act II) THE SOUND of typing can be heard and then suddenly a loud groan of disappointment. DEV LEAD Argggggggggggggggg!!! FADE IN: INT. CORPORATE OFFICE THE DEV LEAD is looking at his bug queue in HP Quality Center, the bug count is 6,894 defects, all assigned to him. [...]
The Comedy and Tragedy of Automated Security Source Code Analysis – Act II
October 11th, 2010 § 5 comments § permalink
ACT II: The Deception (Read Act I Here) FADE IN: WIDE SHOT — The server room, filled with blinking lights and racks of servers. We PAN and FOCUS in on the back of the SALES ENGINEER who is typing away at a terminal. A DEV LEAD sits nearby, looking bored. SALES ENGINEER’S POV — The [...]
The Comedy & Tragedy of Automated Security Source Code Analysis
September 23rd, 2010 § 2 comments § permalink
The other day I was asked about how one might integrate Veracode’s application security analysis solution into their nightly software build process. I get this question all the time because it is a popular idea among automated source code analysis tools and the common sense tells you that it’s one of the best ways to [...]
-
Popular Posts
CrashPlan Central Review – The Perfect Online Backup Solution? 39 comment(s) | 2,738 view(s)
Carbonite – Not Ready for the Real World 26 comment(s) | 1,130 view(s)
Encrypting your data on Amazon EC2 10 comment(s) | 4,827 view(s)- Closure on Carbonite – How to get a Refund 9 comment(s) | 968 view(s)
- The Comedy and Tragedy of Automated Security Source Code Analysis – Act II 5 comment(s) | 47 view(s)
- Filling the music void 4 comment(s) | 1 view(s)
- The Impending Failure of the TechCrunch CrunchPad 4 comment(s) | 40 view(s)
- Ask A Ninja 3 comment(s) | 16 view(s)
- Where's Alice? 3 comment(s) | 1 view(s)
- Progress part 1 2 comment(s) | 1 view(s)