Linq2Xml Remove specific attribute name and their values

Question

I have this XML, and i am trying to delete those: Name="items" Name="shipmentsShipmentIndex"

"Name" is not going to change,

The word that will be change is the word between the quotation marks, in this example: items and shipmentsShipmentIndex

<?xml version="1.0" encoding="UTF-8"?>

 <RootDTO xmlns:json='http://james.newtonking.com/projects/json'>
   <destination>
      <name>XXX</name>
   </destination>
   <orderData>    
      <items json:Array='true'>   
        <shipmentIndex Name="items">0</shipmentIndex>           
      </items>
       <items json:Array='true'>      
        <shipmentIndex Name="items">0</shipmentIndex>           
      </items>

      <shipments json:Array='true'>          
        <shipmentIndex Name="shipmentsShipmentIndex">0</shipmentIndex>                                                          
      </shipments>
   </orderData>
  </RootDTO>

How can i find all these occurrences and remove them(or replace them with nothing)? I tried a bunch of variations like: Name{1}[a-zA-Z]+"\b

Try a basic replacement: `\bName="[^"]*"` => `Name="NEW_VALUE"` — Wiktor Stribiżew, Feb 09 '16 at 12:06
@WiktorStribiżew didn't understand you solution- "Try a basic replacement" — Eran Meir, Feb 09 '16 at 12:08
http://csharp.net-tutorials.com/xml/reading-xml-with-the-xmlreader-class/ — choroba, Feb 09 '16 at 12:15

score 2 · Answer 1 · edited May 23 '17 at 11:45

2

Don't parse XML with regular expressions. Use an XML aware tool.

For example, in xsh, you can achieve this with

open file.xml ;
rm //@Name ;
save :b ;

edited May 23 '17 at 11:45

Community

1
1

answered Feb 09 '16 at 12:10

choroba

231,213
25
204
289

@WiktorStribiżew: I'm just a maintainer. – choroba Feb 09 '16 at 12:13
i can't add libraries to this project – Eran Meir Feb 09 '16 at 12:13
How can i use it within an asp.net project ? – Eran Meir Feb 09 '16 at 12:16
@EranMeir: You didn't say it's an asp.net project. But see http://stackoverflow.com/questions/7209834/launch-a-program-from-asp-net-c-sharp on how to use anything. – choroba Feb 09 '16 at 12:18
as i said. i can't add any lib or alike to this project. – Eran Meir Feb 09 '16 at 12:27

score 2 · Accepted Answer · answered Feb 09 '16 at 13:06

You wrote this is ASP.NET. You can use Linq2Xml to perform this operation very quickly (LinqPad example):

void Main()
{
    var test = XDocument.Parse("<root><node name=\"name value\">Text</node></root>");
    foreach(var attr in test.Descendants().SelectMany(el=>el.Attributes("name")))
                attr.Remove();

    test.Dump();
}

So from this:

<root>
  <node name="name value">Text</node>
</root>

You get this:

<root>
  <node>Text</node>
</root>

The snippet will remove ALL name attributes from every single element in the XML aside of the root one. If you want to do something else (like just empty the attribute, or include the root element), let me know.

I chose your answer because it more related to my project(asp.net) Thanks — Eran Meir, Feb 09 '16 at 13:12
@EranMeir: Next time, don't forget to tag your question properly, please. — choroba, Feb 09 '16 at 15:24

Harpreet Singh · Answer 3 · 2016-02-09T12:48:20.340

1

Try this RegEx:

Name=\"(.*?)\"

edited Feb 09 '16 at 12:48

answered Feb 09 '16 at 12:19

Harpreet Singh

2,651
21
31

Can you please share it with [this tool](http://regexr.com/) or other tool (showing the example? i cant manage to get it to work – Eran Meir Feb 09 '16 at 12:25
@EranMeir the link you have added is for Javascript regex only. Try this link - https://myregextester.com/. I am unable to save test in this url. – Harpreet Singh Feb 09 '16 at 12:28
You can use [Regexstorm.net](http://regexstorm.net/tester) to share links to .NET regex – Wiktor Stribiżew Feb 09 '16 at 12:32
@WiktorStribiżew Thanks, I ave tested it but unable to save. – Harpreet Singh Feb 09 '16 at 12:35
i am getting "0 matches found" – Eran Meir Feb 09 '16 at 12:35
See [this link](http://goo.gl/IKqksc) showing my suggestion. You can remove the `Name` completely like that. See the *Context* tab to see the replacement result. – Wiktor Stribiżew Feb 09 '16 at 12:37
i need "Name=" to be selected also – Eran Meir Feb 09 '16 at 12:38

Linq2Xml Remove specific attribute name and their values

3 Answers3