extract all instances of text between double quotes

[nikolay100]

Hi,

I want to extract all instances of text between double quotes and separated them with a semicolon or other symbol. I found a lot of examples to extract the text between 2 characters, but they work for only one instance.

Here is my example:

initial value	Expected result
<div><div><div><a href="/img/1630414366_1200_1.jpeg"><img src="/img/thumbnails/1630414366_thumbnail_1.jpeg" /></a><a href="/img/1630414388_1200_2.jpeg"></div></div></div>	/img/1630414366_1200_1.jpeg;/img/thumbnails/1630414366_thumbnail_1.jpeg;/img/1630414388_1200_2.jpeg

The values could be separated with another symbol/character, as long there is a way to differentiate each value.

Thank you in advance.

 

[Peter_SSs]

Could this work for you?

22 10 15.xlsm
	A	B
1	initial value	Expected result
2	<div><div><div><a href="/img/1630414366_1200_1.jpeg"><img src="/img/thumbnails/1630414366_thumbnail_1.jpeg" /></a><a href="/img/1630414388_1200_2.jpeg"></div></div></div>	/img/1630414366_1200_1.jpeg;/img/thumbnails/1630414366_thumbnail_1.jpeg;/img/1630414388_1200_2.jpeg
Extract

Cell Formulas
Range	Formula
B2	B2	=LET(ts,TEXTSPLIT(A2,""""),TEXTJOIN(";",1,INDEX(ts,SEQUENCE(,COLUMNS(ts)/2,2,2))))

 

[nikolay100]

That worked perfectly. Thank you.

 

[Peter_SSs]

You are very welcome. Thanks for the follow-up.