Google Sheets is a great tool to interactively work with an assortment of APIs to work as an intermediary database for experiments or small scale data processing. Here we’re going to look at how we can query our Quickbooks data and display it in a sheet to then merge with any other data set like Read More
Code
Adding a WordPress Blog to Your Rails App
If you’re running a rails application with a blog like I was, you we’re probably using something that utilized jekyl. There are some good blogging platforms out there and when I decided to add a blog to my site, I decided to use toto. At the time I thought adding all the html tags myself Read More
Google Sheets Formulas
Some google sheeets formulas to manipulate data in the cloud. Items will be added as I make use of new formulas. Index Split cell at a specific character or set of characters
|
1 2 3 |
//1. Split cell at a specific character or set of characters // where B2 contains multiple words to be split at a comman and a space which will split into C2 and D2 =SPLIT(B2,", ") |
Sublime Text 2 Commands to Simplify Your Life
The following are shortkeys I use frequently to prevent carpal tunnel syndrome. A habit learned from playing Star Craft in high school. Who says video games are bad for you? Index Split selection based on new line Wrap selection in tags Auto indent Indent right Indent Left Comment / Uncomment Find Find and Replace Find Read More
Data Manipulation
Just a bin of macros and sql queries I use to manipulate data in excel or mysql Index Scan Top of Row Till End and return 3 columns Opposite of Lineemup Delete Rows When Second Column Is Blank Delete everything after certain character in quotes: Remove everything left of NTH character Remove everything left and Read More