nikolay100
New Member
- Joined
- Oct 14, 2022
- Messages
- 6
- Office Version
- 2021
- Platform
- Windows
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:
The values could be separated with another symbol/character, as long there is a way to differentiate each value.
Thank you in advance.
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.