extract part of xml from a string

Question

i have a xml response in string..

 string rerricingresponsexml= xmlvalue;

the xmlvalue is

   <?xml version="1.0" encoding="UTF-8"?>
<Repricing>
  <Flights>
    .....
  </Flights>
</Repricing>

Now i want to extract <Flights> to \</Flights>

I tried

        XmlDocument doc = new XmlDocument();
        doc.Load(rerricingresponsexml);

        XmlNode headerNode = doc.SelectSingleNode("RePricing");
        if (headerNode != null)
        {
            string headerNodeXml = headerNode.OuterXml;
        }

But it says Illegal character in xml.. Any help please..

Question might be same, but the provided answers are different... — Sasidharan, Sep 27 '13 at 11:14

score 6 · Accepted Answer · answered Sep 27 '13 at 06:59

6

Try this:

var xml = XElement.Parse(xmlString);
var flights = xml.DescendantsAndSelf("Flights");

It will return IEnumerable<XElement>. If you want to get it as string you can use this:

string.Concat(flights.Nodes())

answered Sep 27 '13 at 06:59

Hamlet Hakobyan

32,965
6
52
68

Awesome @Hamlet Hakobyan...It worked like honey.. – Sasidharan Sep 27 '13 at 07:25

Sergey Berezovskiy · Answer 2 · 2013-09-27T07:10:51.793

0

Xml is case-sensitive. Use Repricing instead of RePricing. Also you should load xml string with LoadXml method. When you using Load method, document tries to load non-existing file:

doc.LoadXml(rerricingresponsexml);
XmlNode headerNode = doc.SelectSingleNode("Repricing");

Also consider to use Linq to Xml for parsing:

var xdoc = XDocument.Parse(rerricingresponsexml);
var flights = from f in xdoc.Root.Elements("Flights").Elements()
              select new {
                  SearchId = (string)f.Element("SearchId"),
                  Currency = (string)f.Element("Currency"),
                  AdultPrice = (decimal)f.Element("AdultPrice"),
                  // etc
                  Legs = from l in f.Element("LegDetails").Elements()
                         select new {
                             AirLineCode = (string)l.Element("AirLineCode"),
                             FromSector = (string)l.Element("FromSector"),
                             ToSector = (string)l.Element("ToSector")
                             // etc
                         }
              };

edited Sep 27 '13 at 07:10

answered Sep 27 '13 at 06:55

Sergey Berezovskiy

232,247
41
429
459

its not getting into that..i m getting error in doc.Load() – Sasidharan Sep 27 '13 at 06:57
The OP says he gets an error on `.Load`, not on `.SelectSingleNode`. I'm not sure if this would resolve his issue – default Sep 27 '13 at 06:57
i thought its because of ...and i replaced this with null..even though its hitting same error – Sasidharan Sep 27 '13 at 06:58
@Sasidharan see update - Looad method should be used to load XmlDocument from file. So, document tries to load file with name which is your xml response – Sergey Berezovskiy Sep 27 '13 at 06:59
ok is there any other work around for this.. – Sasidharan Sep 27 '13 at 07:01
@Sasidharan what do you mean by workaround? You are using wrong method for loading xml. Use correct one. This is a fix, not workaround – Sergey Berezovskiy Sep 27 '13 at 07:05

score 0 · Answer 3 · answered Sep 27 '13 at 06:57

0

Use LinqToXML ad you will be fine with just two lines of code:

XDocument doc = XDocument.Load(rerricingresponsexml);
string flightDetails= doc.Descendants("Flights").SingleOrDefault().ToString();

Hope it helps!

answered Sep 27 '13 at 06:57

Sunny Sharma

4,688
5
35
73

extract part of xml from a string

3 Answers3