regex to match link inside xml with last mod

Question

<?xml version='1.0' encoding='UTF-8'?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url><loc>https://google.com/2020/08/this1.html</loc><lastmod>2020-08-06T11:30:55Z</lastmod></url>
<url><loc>https://google.com/2020/08/this2.html</loc><lastmod>2020-08-05T11:30:06Z</lastmod></url>
<url><loc>https://google.com/2020/08/this3.html</loc><lastmod>2020-08-06T11:29:25Z</lastmod></url>
</lastmod></url></urlset>

I'm trying to get links from above xml to get links which has lastmod of 2020-08-06 my regex code is https:.+2020-08-05.+<\/url

but it ended up getting it all from 1st and last link

I want to match only

<url><loc>https://google.com/2020/08/this1.html</loc><lastmod>2020-08-06T11:30:55Z</lastmod></url>
<url><loc>https://google.com/2020/08/this3.html</loc><lastmod>2020-08-06T11:29:25Z</lastmod></url>

Is there any reason why you are using regex for this? I mean, XML isn't made to be parsed with regex. — maio290, Aug 13 '20 at 05:47
I'm using a php script webscrape to get links from xml, thats the only simpler way to do it that I can think of :/ — Kenneth Gervacio, Aug 13 '20 at 05:49
@rootkonda thanks for the reply, that only match the first instance, but thanks I'll look it up how to match all instances. THanks — Kenneth Gervacio, Aug 13 '20 at 05:51
@rootkonda sorry, that solves it :D, my code wasn't using /g tahts why it only match first thanksss — Kenneth Gervacio, Aug 13 '20 at 05:52
@Kenneth - You can use global mode to match all instances. `/(.+)<\/loc>.*2020-08-06/g` — rootkonda, Aug 13 '20 at 05:52
@KennethGervacio If you are using php, you could use a parser https://stackoverflow.com/questions/3577641/how-do-you-parse-and-process-html-xml-in-php?rq=1 — The fourth bird, Aug 13 '20 at 06:33

score 0 · Answer 1 · answered Aug 13 '20 at 05:53

0

A very easy and stupid regex - see regexr:

.*<lastmod>2020-08-06.*

answered Aug 13 '20 at 05:53

maio290

6,440
1
21
38

my code works its just that the xml wasn't correctly parse? – Kenneth Gervacio Aug 13 '20 at 06:04

score 0 · Accepted Answer · answered Aug 13 '20 at 05:55

0

/<loc>(.+)<\/loc>.*2020-08-06/g

capturing the group between loc tags Demo and explanation here: https://regex101.com/r/HBvG3K/8

answered Aug 13 '20 at 05:55

rootkonda

1,700
1
6
11

regex to match link inside xml with last mod

2 Answers2