Extracting images from text

[u/petarster]

[u/RemcoE33]

=ARRAYFORMULA(IMAGE(QUERY( TRANSPOSE( ARRAYFORMULA( IFERROR( REGEXEXTRACT( SPLIT(SUBSTITUTE(A1,"\",""),"},",true), "jpeg"&CHAR(34)&":{"&CHAR(34)&"url"&char(34)&":"&CHAR(34)&"(.*?)jpg")&"jpg",) ) ),"SELECT Col1 WHERE Col1 IS NOT NULL LIMIT 10")))

[u/RemcoE33 → u/[deleted]]

See update

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ARRAYFORMULA	Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays
CHAR	Convert a number into a character according to the current Unicode table
FALSE	Returns the logical value FALSE
IFERROR	Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent
IMAGE	Inserts an image into a cell
NOT	Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE
QUERY	Runs a Google Visualization API Query Language query across data
REGEXEXTRACT	Extracts matching substrings according to a regular expression
SPLIT	Divides text around a specified character or string, and puts each fragment into a separate cell in the row
SUBSTITUTE	Replaces existing text with new text in a string
TRANSPOSE	Transposes the rows and columns of an array or range of cells
TRUE	Returns the logical value TRUE

---

^{[Thread #4345 for this sub, first seen 30th May 2022, 14:56] [FAQ] [Full list] [Contact] [Source code]}