Extract node from XML document

Question

I have this XML:

<WMFWUpload>
         <Date></Date>
         <GroupIndex></GroupIndex>
         <Id></Id>
         <NumGroups></NumGroups>
         <NumRecs></NumRecs>
         <Receipts>
            <Receipt>
               <CreationDateTimeStamp></CreationDateTimeStamp>
               <CreationProcessStamp></CreationProcessStamp>
               <DateTimeStamp></DateTimeStamp>
               <InterfaceRecordId />
               <ProcessStamp></ProcessStamp>
               <UserStamp></UserStamp>
            </Receipt>
         </Receipts>
</WMFWUpload>

I read the document from a path and I want to select only the Recepit Node, but not only the values also the nodes, and the result should be:

<Receipt>
    <CreationDateTimeStamp></CreationDateTimeStamp>
    <CreationProcessStamp></CreationProcessStamp>
    <DateTimeStamp></DateTimeStamp>
    <InterfaceRecordId />
    <ProcessStamp></ProcessStamp>
    <UserStamp></UserStamp>
</Receipt>

This is my code so far, I'm stuck.

  XDocument doc = XDocument.Load(@"C:\Users\Daniel\Documents\Pite\Selmec\WorkingData\Origen\ReceivingUpload.xml");
            var query = from c in doc.Descendants("Receipt").DescendantsAndSelf().ToList() select c;

            foreach (var value in query)
            {
                Console.WriteLine(value);
            }

            Console.ReadLine();

Possible duplicate of [Getting specified Node values from XML document](http://stackoverflow.com/questions/6442024/getting-specified-node-values-from-xml-document) — lokusking, Aug 02 '16 at 18:27
That code is diferent I want all my output in a string value. they select some values — Danielopez .., Aug 02 '16 at 18:29

Mostafiz · Accepted Answer · 2016-08-02T18:56:11.393

0

Use this

var query = doc.Descendants("Receipt");
string s = string.Concat(query);

Update

Make sure to have this line <?xml version="1.0" encoding="utf-8"?> on top of your xml file

I have used this xml

<?xml version="1.0" encoding="utf-8"?>
<WMFWUpload>
         <Date></Date>
         <GroupIndex></GroupIndex>
         <Id></Id>
         <NumGroups></NumGroups>
         <NumRecs></NumRecs>
         <Receipts>
            <Receipt>
               <CreationDateTimeStamp></CreationDateTimeStamp>
               <CreationProcessStamp></CreationProcessStamp>
               <DateTimeStamp></DateTimeStamp>
               <InterfaceRecordId />
               <ProcessStamp></ProcessStamp>
               <UserStamp></UserStamp>
            </Receipt>
         </Receipts>
</WMFWUpload>

edited Aug 02 '16 at 18:56

answered Aug 02 '16 at 18:28

Mostafiz

7,243
3
28
42

Which is the same as just `doc.Descendants("Receipt")`. – Charles Mager Aug 02 '16 at 18:28
I didit already, but I dont recieve a string or anything I'm missing something, beacuase the result is System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Xml.Linq.XElement,System.Xml.Linq.XElement] – Danielopez .. Aug 02 '16 at 18:32
so you want all as a string ? – Mostafiz Aug 02 '16 at 18:34
@Danielopez.. does it help ? – Mostafiz Aug 02 '16 at 18:49
@Mostafiz it doesnt, the value in 's' is empty – Danielopez .. Aug 02 '16 at 18:52
does your xml have `` line at the begining ? because its working for me – Mostafiz Aug 02 '16 at 18:55
@Mostafiz it works with the code above but actually its a file bigger and with namespaces, I dont know if this afects the code – Danielopez .. Aug 03 '16 at 15:59

Extract node from XML document

1 Answers1