EDN Admin
Well-known member
Hi,
Im reading in the following xml data below. I am trying to isolate on any tag/node that contains the literal "filler" and weed-out the rest when the file is saved.
I tried to use this code unsuccessfully:
Dim xmlFile = XDocument.Load("Main.xml")
Dim xNoFiller As XDocument = <?xml version="1.0" encoding="utf-8"?>
<Rows> _
<%= From qRw As XElement In xmlFile.Element("Rows").Elements _
Where qRw.Element("Filler").Value <> "" _
Select Rw = qRw _
Order By Rw.Attribute("SortOrder") %> _
</Rows>
Id appreciate any insight to accomplishing this using VS and VB 2010.
Thanks in advance.
------------
<?xml version="1.0" encoding="utf-8"?>
<Rows> _
<Row Sortorder="1
<span style="white-space
re <Field1 Deleteme="false 1</Field1>
<span style="white-spacere <Field2 Deleteme="false </Field2>
<span style="white-spacere <Field3 Deleteme="false </Field3>
<span style="white-spacere <Field4 Deleteme="false </Field4>
<span style="white-spacere <Field5 Deleteme="false </Field5>
<span style="white-spacere <Filler Deleteme="false filler</Filler>
</Row>
<Row Sortorder="1
<span style="white-spacere <Field1 Deleteme="false </Field1>
<span style="white-spacere <Field2 Deleteme="false </Field2>
<span style="white-spacere <Field3 Deleteme="false </Field3>
<span style="white-spacere <Field4 Deleteme="false </Field4>
<span style="white-spacere <Field5 Deleteme="false </Field5>
<span style="white-spacere <Filler Deleteme="false </Filler>
</Row>
<Row Sortorder="1
<span style="white-spacere <Field1 Deleteme="false </Field1>
<span style="white-spacere <Field2 Deleteme="false </Field2>
<Field3 Deleteme="false </Field3>
<Field4 Deleteme="false </Field4>
<Field5 Deleteme="false </Field5>
<Filler Deleteme="false </Filler>
</Row>
<Row Sortorder="2
<Field1 Deleteme="false 2</Field1>
<Field2 Deleteme="false </Field2>
<Field3 Deleteme="false </Field3>
<Field4 Deleteme="false </Field4>
<Field5 Deleteme="false </Field5>
<Filler Deleteme="false filler</Filler>
</Row>
<br/>
View the full article
Im reading in the following xml data below. I am trying to isolate on any tag/node that contains the literal "filler" and weed-out the rest when the file is saved.
I tried to use this code unsuccessfully:
Dim xmlFile = XDocument.Load("Main.xml")
Dim xNoFiller As XDocument = <?xml version="1.0" encoding="utf-8"?>
<Rows> _
<%= From qRw As XElement In xmlFile.Element("Rows").Elements _
Where qRw.Element("Filler").Value <> "" _
Select Rw = qRw _
Order By Rw.Attribute("SortOrder") %> _
</Rows>
Id appreciate any insight to accomplishing this using VS and VB 2010.
Thanks in advance.
------------
<?xml version="1.0" encoding="utf-8"?>
<Rows> _
<Row Sortorder="1
<span style="white-space
re <Field1 Deleteme="false 1</Field1> <span style="white-space
re <Field2 Deleteme="false </Field2> <span style="white-space
re <Field3 Deleteme="false </Field3> <span style="white-space
re <Field4 Deleteme="false </Field4> <span style="white-space
re <Field5 Deleteme="false </Field5> <span style="white-space
re <Filler Deleteme="false filler</Filler> </Row>
<Row Sortorder="1
<span style="white-space
re <Field1 Deleteme="false </Field1> <span style="white-space
re <Field2 Deleteme="false </Field2> <span style="white-space
re <Field3 Deleteme="false </Field3> <span style="white-space
re <Field4 Deleteme="false </Field4> <span style="white-space
re <Field5 Deleteme="false </Field5> <span style="white-space
re <Filler Deleteme="false </Filler> </Row>
<Row Sortorder="1
<span style="white-space
re <Field1 Deleteme="false </Field1> <span style="white-space
re <Field2 Deleteme="false </Field2> <Field3 Deleteme="false </Field3>
<Field4 Deleteme="false </Field4>
<Field5 Deleteme="false </Field5>
<Filler Deleteme="false </Filler>
</Row>
<Row Sortorder="2
<Field1 Deleteme="false 2</Field1>
<Field2 Deleteme="false </Field2>
<Field3 Deleteme="false </Field3>
<Field4 Deleteme="false </Field4>
<Field5 Deleteme="false </Field5>
<Filler Deleteme="false filler</Filler>
</Row>
<br/>
View the full article