Using Regexp for search XML

Question

How can I search an xml file by Regex and get specific attribute value in Delphi?

For example in this xml:

<?xml version=”1.0” encoding=”UTF-8” ?> 
<School>
    <Class>
        <StudentID> 1 </StudentID> 
        <StudentName> Joe </StudentName> 
        <StudentFamily> Brown </StudentFamily> 
    </Class>
    <Class>
        <StudentID> 2 </StudentID> 
        <StudentName> Michel </StudentName> 
        <StudentFamily> Adams </StudentFamily> 
    </Class>
    <Class>
        <StudentID> 3 </StudentID> 
        <StudentName> Joel </StudentName> 
        <StudentFamily> Thompson </StudentFamily> 
    </Class>

</School>

That is, searching for “Joe*” (in StudentName attribute) the code should return “Brown” and “Thompson” (from StudentFamily attribute).

I can use FindNode function for xmlDocument in simple cases, but I have to use Regex.

Any idea is welcome.

Are there any language restrictions for the regex you're writing? Also, is there a reason you can't just use xpath for this? — SuperFamousGuy, Jan 21 '14 at 11:44
This question has already been answered by bobince: http://stackoverflow.com/questions/1732348/regex-match-open-tags-except-xhtml-self-contained-tags/1732454#1732454 — David Heffernan, Jan 21 '14 at 12:42
FWIW, I did not cast a duplicate close vote. Mine was for "unclear what you are asking". — David Heffernan, Jan 21 '14 at 14:52
Thanks David,in fact my question is about searching nodes by regex, and return related nodes in Delphi. I can do the search properly, but can not get related nodes in delphi. — Mohsen Noroozi, Jan 21 '14 at 20:48

score 0 · Answer 1 · answered Jan 21 '14 at 11:51

0

How about: (?:\<StudentName\> Joe.* \<\/StudentName\>[\s]*<StudentFamily>\s*)(\w*) Of course, you have to build the pattern and put "Joe*" as "Joe.*" in the right place

answered Jan 21 '14 at 11:51

Uri Y

840
5
13

score 0 · Answer 2 · answered Jan 21 '14 at 11:55

0

Try :

(?:<StudentName>\sjoe[^< ]*).*?\n.*?<StudentFamily>([^<]*)

Demo

Explanation : enter image description here

answered Jan 21 '14 at 11:55

Sujith PS

4,776
3
34
61

Using Regexp for search XML

2 Answers2