mysql to csv via sed

mysql -uexampleuser -pletmein exampledb -B -e “select * from \`person\`;” | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ > filename.csv

Read Full Post »

Examples of report/whitepaper landing pages

CJR: one way, not to my liking…. but…. admob: another… also blah… better but not so hot … – (but they do provide raw data, which is interesting) Ektron/Sitepoint: A survey sponsored by two co’s and available for $$ does a little more packaging Forrester: Like above, but “now, with more Blah!” Gartner: less blah.

Read Full Post »

Fun with find

# find all .html files in the current directory and sub directories find . -name “*.html” -type f -print # find all “dot” directories find /Users/smbrown -name “.*” -type d -print # find all “dot” files find /Users/smbrown -name “.*” -type f -print # find all dot files, but omit the pesky OS X .DS_Store [...]

Read Full Post »

Some DiG/DNS/nslookup tid bits

Get ttl for a domain: [smbrown@JRCASH-3:~]$ dig +nocmd seanmbrown.net +noall +answer seanmbrown.net. 3574 IN A 174.143.45.137 Flush the dns cashe on Mac OS X [smbrown@JRCASH-3:~]$ dscacheutil -flushcache

Read Full Post »