=RIGHT(A1;LEN(A1) -SEARCH("[^\s]+$";A1)+1)
=RIGHT(A1;LEN(A1) -SEARCH("[^\s]+$";A1)+1)
=substitute(A2;B2;"")
=left(A2;len(A2)-len(B2))
<img src=''https://a.allegroimg.com/s1440/01bbc8/277586794e3baa4f63c35d0b0bb8''
https://a.allegroimg.com/s1440/01bbc8/277586794e3baa4f63c35d0b0bb8
</div>
</section>
<section class=''section''>
<div class=''item item-6''>
<section class=''image-item''>
<img src=''https://a.allegroimg.com/s1440/01ccf7/b6dc32034eb491aec55870ea58e4'' srcset=''https://a.allegroimg.com/s360/01ccf7/b6dc32034eb491aec55870ea58e4 360w, https://a.allegroimg.com/s720/01ccf7/b6 ... 5870ea58e4 720w, https://a.allegroimg.com/s1024/01ccf7/b ... 5870ea58e4 806w'' sizes=''(min-width: 1200px) 560px, (min-width: 992px) 50vw, 100vw'' width=''806px''/>
</section>
</div>
=LEFT(MID(A1;FIND("http";A1;1);LEN(A1));FIND(" ";MID(A1;FIND("http";A1;1);LEN(A1));1))
<id>550124</id><guid>238974shdbf23874dgf23hr</guid><id>550125</id><guid>238974shdbf23874dgf23hr</guid><id>550126</id><guid>238974shdbf23874dgf23hr</guid><id>5503454</id> <guid>238974shdbf23874dgf23hr</guid><id>550456</id> <guid>238974shdbf23874dgf23hr</guid><id>550456</id><guid>238974shdbf23874dgf23hr</guid>
<guid>[^<]+</guid>
</id>\s*<id>
FJCC wrote:If you are willing to use Find & Replace in a couple of steps, you can do the following. This assumes that, like your example, there are only two types of tags. First search for
- Code: Select all Expand viewCollapse view
<guid>[^<]+</guid>
and use Replace All with the Replace With box empty.
Then search for
- Code: Select all Expand viewCollapse view
</id>\s*<id>
and use Replace All with the Replace With box containing a comma. That will leave you with just the lead and trailing id tags to delete. You can then use Text To Columns to split the numbers into individual cells.
[^<]+
<id>550124</id><guid>238974shdbf23874dgf23hr</guid><id>550125</id><guid>238974shdbf23874dgf23hr</guid><id>550126</id><guid>238974shdbf23874dgf23hr</guid><id>5503454</id> <guid>238974shdbf23874dgf23hr</guid><id>550456</id> <guid>238974shdbf23874dgf23hr</guid><id>550456</id><guid>238974shdbf23874dgf23hr</guid>
Users browsing this forum: Google [Bot] and 10 guests