Jim O'Flaherty
Jim O'Flaherty
**Justification** As a codebase grows, the probability of a naming conflict arising among public subs and functions as external modules and/or new modules are added increases quickly. There is a...
Refactor Excel Worksheet Formulas containing VBA function calls to depend upon a "formula facade"...
**Justification** By creating one level of indirection via a "formula facade", the goal is to reduce, inhibit, and eventually eliminate change propagations in both directions between Excel formulas and the...
**What** As a Code Quality/Integrity focus, it would be great to be able to turn on an inspection that catches any (silent) VBA auto-conversion between data types. Coming from strongly...
**What** It would be nice to see 64bit VBA only things, like `LongLong`, highlighted with an inspection. Actually, it would be great to show anything that is 32bit VBA only...
> I don't have the time (and for most others, the motivation) to try and figure these out as it would cause me to lose my current focus (evaluating a...
### **Summary:** When consuming a pipe-delimited file, the parser becomes erratic with `CsvConfiguration('|', '"', QuotePolicy.Always, Header.None)`. The first time a pipe character is immediately followed by a double-quote character [ex:...
If you are looking for a more fleshed-out implementation of Geohash related functions for TSQL, I have just published an Open Source library, [QalGeohash-TSQL](https://github.com/qalocate/qalgeohash-tsql) in which you might be interested.