Check for non-numeric data in mysql
This will list the non-numeric data values in a mysql column.
[Read More]
-
-
Read the Descriptions from all columns in MS Access database
By John C. ZastrowFrom one of my developers. This VBA (couldn’t find an approach in .Net) will loop through all the tables and write out the description from all the fields. [Read More] -
Handy database documenter/profiler for mysql, cont.
By John C. ZastrowSome time ago I wrote down a little script to make a table from the MySQL information schema to describe your database. My eventual goal is to come close to reproducing a poor man’s database profiling script similar to this crude one ( http://www.ipcdesigns.com/data_profiling/), but perhaps less powerful and yet... [Read More] -
Wish I didn’t invest in the iPad2
By John C. ZastrowAfter much deliberation we plunked down the plastic for an iPad2. It was supposed to be a gift for me.. though I likely use it the least of all people over the age of 2 in this house. It shipped much faster than expected and just in time for the... [Read More] -
Use Excel’s MID and FIND to extract characters from varying positions
By John C. ZastrowUse this to grab the values after a certain value, of the whole string the value doesn’t exist. The concatenation ensure that the value is always found. The final Len(A1) forces the entire length of the string after the value to be shown regardless of what it it. the final... [Read More] -
USGS GNIS column names and shapefiles
By John C. ZastrowIf you try to convert the USGS geographic names (GNIS) text files from the website straight into shapefiles, you will have field name collisions because the field names willbe truncated to 10 characters which result in duplicate field names. [Read More] -
PostGIS Install and Cloning Ubuntu Systems Notes
By John C. Zastrowsudo apt-get remove –purge\ [Read More] -
find to copy files into single directory
By John C. ZastrowUseful little one liners. This one makes copy of subset of dir/ and below based on finding files that match the criteria. In this case, I wanted all .doc files copied into a single place. [Read More] -
My MySQL latest config file
By John C. ZastrowI never record this stuff and I always wish I did. So here’s a working MySQL config file that I’m using on a linux virtual machine with 2GB of memory. Notes and all so I don’t keep having to look stuff up. [Read More] -
File listing ditties
By John C. ZastrowHere are some simple bash scripts to list files into a text files that can be used to catalog stuff. Most of the time I use the last one. ```bash [Read More]