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 […]
I loved both expressions. It’s interesting to see just how aware kids are of cameras. I don’t know if that’s always been the case. Some of the posing I’ve seen, not these kids, has certainly been a more recent development. I don’t often take pictures of flowers but I liked this one. I’ve remain fascinated by grass seeds like this. The lettering of the sign is really interesting as is what it says. You can see the tiny trail of a bug in the dew and then the wing imprint and claw marks of a bird as it swooped down and plucked it off.