Monthly Archives: October 2014

Uncategorized

sql :: reformatting HTML to plain text

I received a request from a colleague asking me if I could reformat HTML in a cell to be readable so we could send it out to a customer (mssql db). Initially, I thought “easy”. How wrong I was.
As per normal, I scoured the net, as I’m sure someone else has done this, and came across , which is awesome, but its too generic. It strips everything between <> tags. We have embedded xml sometimes and I still need that to be displayed. Looks like I have to put all the HTML tags in that need to be stripped, individually…
read more »

Uncategorized

excel :: displaying vugen response times

I use excel a lot, most performance testers will. It’s powerful when teamed up with funky macros, and can make life easier. It wasn’t always this way.
I feared excel (mainly because i was a n00b using it) but inspiration from my VB developer / performance tester extraordinaire / senior (read:old man) – Gary Cassar, I’ve learnt to embrace the warmth and fuzziness that lies within excel and use it to my advantage. I’ve written a few macros, not amazing, but I’ve been able to get some great results.

One bugbear that I have, is when I copy summary data from HP analysis into Excel. What happens, is that it inserts a whole bunch of images where the “SLA” field is. This screws up the formatting when pasting into word for a funky looking TSR. I used to delete them manually, until old man Gary blasted this out from across the room.
read more »