This was an odd project. Taking several PDFs of layoff data and turning them into text, so they might be used more like a database. This info should be offered up by the state as a database, but it’s not (at least it wasn’t to me). I ended up using a PDF to Text application … Continue reading Turning California WARN PDFs into Text
This is trial code that I used to translate an error from a Yahoo web service into a COM ErrObject. It’s not real XML parsing, but good enough for this purpose. IF an error message is sent, we extract the message and then use Err.Raise to throw an error. Sub testRegex() Dim response As String … Continue reading VBA: Transforming XML Error Messages into VBA Errors (Raising or Throwing Errors)
I was messing around with some textual analysis, trying to figure out how to do a “related articles” feature in Drupal. The problem with most systems is that they require someone to choose tags, which is additional work on top of the writing and initial categorization. This script uses the simple SEO technique of counting … Continue reading Keyword Analysis or Discovery (a first try)
I must admit that I’m fully drunk on the Kool-Ade. The tl;dr : testing isn’t just writing tests, but also using mock objects and services to simplify testing, and using package managers to port code to new versions of modules. It takes days to learn how, but it’s worth it. I used to think of … Continue reading The TDD/BDD Religion, Getting The
