Convert xml to csv - 2

This is a follow on from
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_28600021.html#a40568776

The file I want to use is nearly 8GB.  How can I filter the Linq query to only show a particular OrganizationID or organizationNameTypeCode or OrganizationName_effectiveTo?
AlHal2Asked:
Who is Participating?
 
Fernando SotoConnect With a Mentor RetiredCommented:
Hi AlHal2;

Something like the following code snippet, where the where clause was modified.

// The values to filter on
string origId = "4295856130";
string typeName = "AKA";
string effectiveTo = "2005-08-18T04:00:00";

XElement doc = XElement.Load(@"C:\Working Directory\OAOrganization-File.xml");
string csv = (from el in doc.Descendants()
              let ns = String.Format("{{{0}}}",el.Name.NamespaceName)
              where  el.Name.LocalName == "Organization" && ((el.Element(ns + "OrganizationId").Value == origId) || 
                    (el.Element(ns + "OrganizationName").Attribute("organizationNameTypeCode").Value == typeName) ||
                    (el.Element(ns + "OrganizationName").Attribute("effectiveTo").Value == effectiveTo))
              select String.Format("{0},{1},{2},{3}",
              (string)el.Element(ns + "OrganizationId"),
              (string)el.Element(ns + "AdminStatus").Attribute("effectiveFrom"),
              (string)el.Element(ns + "AdminStatus"),
              Environment.NewLine
              )
              )
              .Aggregate( new StringBuilder(),  (sb, s) => sb.Append(s), sb => sb.ToString()
              );

Open in new window

0
 
AlHal2Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.