One of our tools has usage data that ends up being three items on one line. Each line of data is something like this 1. email@middlebury.edu 123. The first number doesn’t matter. I want the email address and the last number (which indicates usage hours). In the old days, I’d have rigged something together using […]
Read More… from Extracting data using regexextract in Google Sheets
flickr photo shared by CraigMoulding under a Creative Commons ( BY-SA ) license Just two little functions in Google Sheets that came up as we tried to quickly pull comments from a blog for some other work. It was an odd scenario but the techniques should have other useful applications. IMPORTFEED The function below pulls […]
Read More… from Google Sheets Love – REGEXEXTRACT & IMPORTFEED