Displaying embedded images

[Noah GoodmanParticipant]

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

[johnlParticipant]

I haven’t looked too closely as the output, but this did seem to work.

=image(iferror(REGEXEXTRACT(R2,”media_url.:.(http.*).,.media_url_”),””))

[Noah GoodmanParticipant]

Hey John,

Thanks for your reply. I tried using that formula and I get an #ERROR!. Any ideas?

Best,
Noah

[mhawkseyKeymaster]

Hi Noah,

slight variation on johnl’s answer (you might need to adjust the Q2 – this assume entities_str is in column Q:

=IMAGE(IFERROR(REGEXEXTRACT(Q2,"media_url.:.(http.*?).,"),""))

… 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)

=ARRAYFORMULA(IMAGE(IFERROR(REGEXEXTRACT(Q:Q,"media_url.:.(http.*?).,"),"")))

[Noah GoodmanParticipant]

Works beautifully. Thanks Martin and John.

Best,
Noah

[Author]

Posts