Reply To: Displaying embedded images

[mhawksey]

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.*?).,"),"")))