I have been displaying a Tweet’s embedded image in one of the cells in my TAGS sheet using the following formula:
=image(left(REGEXEXTRACT(R2, “media_url[[:punct:]]:[[:punct:]](.*?),”),LEN(REGEXEXTRACT(R2,”media_url[[:punct:]]:[[:punct:]](.*?),”))-1))
It goes into the entities_str cell (R2 here) and pulls the url that follows the string media_url”:” and proceeds the next quotation mark.
I know that someone with a better handle on RegEx could write a much cleaner function and was wondering if someone might be able to help.
Thanks,
Noah