How to do string replace in Xml format string

Question

I have a xml format string stored in a database which is as below

First one

<Query name="test">    <Description />    
<Columns>      

<Column caption="Activities Name" sorting="None" sortIndex="-1">        
    <Expr class="ENTATTR" id="Activities.ActivityDescription" />      
</Column>      

<Column caption="Activities Group" sorting="None" sortIndex="-1">        
<Expr class="ENTATTR" id="{Activity Groups}.ActivityGroupDescription" />      
</Column>    

</Columns>    

<JustSortedColumns />    

<Conditions linking="All" />  
</Query>

In another table, the following xml has stored.

second one

<Columns>      

<Column caption="Activities Note" sorting="None" sortIndex="-1">        
    <Expr class="ENTATTR" id="Activities.Notes" />      
</Column>      

<Column caption="Activities Group" sorting="None" sortIndex="-1">        
<Expr class="ENTATTR" id="{Activity Groups}.ActivityGroupDescription" />      
</Column>    

</Columns>

I need to replace string between '<columns>' and '</columns>' from second one to first one. so after replacement:

First one string must be as below:

    <Query name="test">    <Description />    
<Columns>      

    <Column caption="Activities Note" sorting="None" sortIndex="-1">        
        <Expr class="ENTATTR" id="Activities.Notes" />      
    </Column>      

    <Column caption="Activities Group" sorting="None" sortIndex="-1">        
    <Expr class="ENTATTR" id="{Activity Groups}.ActivityGroupDescription" />      
    </Column>    

</Columns>     

<JustSortedColumns />   

<Conditions linking="All" />  
</Query>

Editing XML with String.Replace/Concat is generally bad idea. Consider not doing it. Also consider editing your post with code that you've tried and have problem with... — Alexei Levenkov
– Alexei Levenkov, Commented Mar 12, 2014 at 23:30
Always use an XML API to edit XML. Something like LINQ to XML. — John Saunders
– John Saunders, Commented Mar 12, 2014 at 23:33

StriplingWarrior · Accepted Answer · 2014-03-12 23:38:02Z

Using LINQ to XML:

Test setup code:

var s1 = @"<Query name=""test"">    <Description />    
<Columns>      

<Column caption=""Activities Name"" sorting=""None"" sortIndex=""-1"">        
    <Expr class=""ENTATTR"" id=""Activities.ActivityDescription"" />      
</Column>      

<Column caption=""Activities Group"" sorting=""None"" sortIndex=""-1"">        
<Expr class=""ENTATTR"" id=""{Activity Groups}.ActivityGroupDescription"" />      
</Column>    

</Columns>    

<JustSortedColumns />    

<Conditions linking=""All"" />  
</Query>";
var s2 = @"<Columns>      

<Column caption=""Activities Note"" sorting=""None"" sortIndex=""-1"">        
    <Expr class=""ENTATTR"" id=""Activities.Notes"" />      
</Column>      

<Column caption=""Activities Group"" sorting=""None"" sortIndex=""-1"">        
<Expr class=""ENTATTR"" id=""{Activity Groups}.ActivityGroupDescription"" />      
</Column>    

</Columns>  ";

Actual code:

var x1 = XElement.Parse(s1);
var x2 = XElement.Parse(s2);

x1.Descendants("Columns").Single()
    .ReplaceAll(x2.Descendants("Column"));
var result = x1.ToString();

Collectives™ on Stack Overflow

How to do string replace in Xml format string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related