via the magical XKCD Fun being a fairly relative term . . . but I’m amused. The Meat You can write custom functions in Google Spreadsheets and then use them like other built in functions. I didn’t realize that. The script belowWhich works but feels like it has an extra array it shouldn’t need . . . I’m still really fumbling with fundamentals here. I’m not sure if I say that in defense or in the interest of transparency. You’ll have to ask the psychologist I have yet to hire. grabs all the URLs from a chunk of text. You could add it to your spreadsheet in Google by going to Tools>Script Editor and opening a blank project. Replace all of the content with this and then save it. You can now use it like other functions by putting =findULR(A1) (assuming A1 is the text chunk you want). It spits out a single cell with the URLs in it on individual lines and with a count of the URLs found at the top of that cell. I’ve commented up the script below in case you want to understand/change it to better suit your needs. Next Steps The regex works well about 90-95% of the time. So it sure beats doing it by hand but it could be improved. You can […]
It is still January right? Instead of looking through all my images or even culling the weekly summaries I opted to see which ones had lingered in my head. These are the ones I remembered. Some of them were pretty popular on the Internets but others received little attention. This is an unposed image of my grandfather’s girlfriend at his funeral. One of the pictures I missed that lingered. I can’t find or erased another of a woman holding her hand up to the glass of a window at night. I must do a better job with metadata.