LINQ Find and replace exact match data in xml file

Question

question

TZacks-2728 asked Mar 20, '21 Viorel-1 commented Mar 21, '21

LINQ Find and replace exact match data in xml file

i am finding and replacing data in xml now by linq this way

 XDocument xmlDoc = XDocument.Load(files);
    
                             var items = (from item in xmlDoc.Descendants("TickerBrokerStandardDateLineitemValue")
                                          where item.Element("TabName").Value.Trim().ToUpper() == olditem.Trim().ToUpper()
                                          select item).ToList();
    
                             foreach (var item in items)
                             {
                                 item.Element("TabName").SetValue(newitem);
                             }
                             xmlDoc.Save(files);

it is working but the problem is if there few values for TabName field looks bit similar then those data also updating.

see two data for TabName
1) Net Revenue
1) Net Revenue Consolidated

so when i will replace only Net Revenue then Net Revenue Consolidated is also updated which i do not want. i want to search by exact tabname value and replace that exact data not other similar data.

how to achieve it with LINQ?

i found one link but not sure does it solve my purpose @AngelinaJoli second answer
https://forums.asp.net/t/2124481.aspx?LINQ+How+to+Check+only+matching+string+based+on+conditions+in+LINQ+Query

please share a code example. thanks

dotnet-csharp

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-03-20T17:44:03.437Z

Viorel-1 answered Mar 20, '21 Viorel-1 commented Mar 21, '21

Try this code:

 var items = from item in xmlDoc.Descendants("TickerBrokerStandardDateLineitemValue").Elements("TabName")
    where item.Value.Trim().ToUpper() == olditem.Trim().ToUpper()
    select item;
        
 foreach (var item in items)
 {
    item.SetValue(newitem);
 }

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TZacks-2728 · Mar 21, 2021 at 07:41 AM

ok i will try but you did not use ToList() at end like

  var items = (from item in xmlDoc.Descendants("TickerBrokerStandardDateLineitemValue").Elements("TabName")
     where item.Value.Trim().ToUpper() == olditem.Trim().ToUpper()
     select item).ToList();

if i construct this way then any problem will occur....please suggest. thanks

0 ·

Viorel-1 TZacks-2728 · Mar 21, 2021 at 08:29 AM

I think that if you need a list of found items (for processing later, multiple times, for example) then use .ToList. To traverse the document one time using your foreach loop, .ToList can be used too, but it is not necessary.

0 ·

question