Extract values from string containing xml data

You have two problems there :

1. Your XML string lacks a root element.

2. The XML string contains ampersands which need to be escaped.

Try this LINQ to XML code which deals with these problems:

using System;

using System.Linq;

using System.Xml.Linq;

class Test

{

static void Main()

{

string xml = "\n";

xml += @"

351

Computer-Wholesale & Manufacturers

278

Computer Software & Services

271

Computer Software Publishers & Developers

xml += "\n";

// replace ampersands with &

xml = xml.Replace("&", "&");

XElement root = XElement.Parse(xml);

var rcs = from rc in root.Elements("relatedCategory") select rc;

foreach(var rc in rcs)

{

int count = (int)rc.Element("count");

string name = (string)rc.Element("name");

Console.WriteLine("Count = {0}, Name = {1}", count, name);

}

Console.ReadKey();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
You have two problems there :

1. Your XML string lacks a root element.

2. The XML string contains ampersands which need to be escaped.

Try this LINQ to XML code which deals with these problems:

using System;
using System.Linq;
using System.Xml.Linq;

class Test
{
static void Main()
{
string xml = "\n";

xml += @"
351
Computer-Wholesale & Manufacturers
278
Computer Software & Services
271
Computer Software Publishers & Developers
";

xml += "\n";

// replace ampersands with &
xml = xml.Replace("&", "&");

XElement root = XElement.Parse(xml);
var rcs = from rc in root.Elements("relatedCategory") select rc;

foreach(var rc in rcs)
{
int count = (int)rc.Element("count");
string name = (string)rc.Element("name");
Console.WriteLine("Count = {0}, Name = {1}", count, name);
}

Console.ReadKey();
}
}
0