I have been displaying a Tweet’s embedded image in one of the cells in my TAGS sheet using the following formula:
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.
I haven’t looked too closely as the output, but this did seem to work.
Thanks for your reply. I tried using that formula and I get an #ERROR!. Any ideas?
slight variation on johnl’s answer (you might need to adjust the Q2 – this assume entities_str is in column Q:
… if you would like to apply this to a column insert a new column and in the header use (again assuming entities_str is in column Q)
Works beautifully. Thanks Martin and John.
You must be logged in to reply to this topic.