split field/value from xml STRING not formatted

Question

I have one string in format of XML, (this is not well-formatted XML!) and I would like to get the field and value

 <MYXML
address="rua sao carlos, 128" telefone= "1000-222" service="xxxxxx" source="xxxxxxx" username="aaaaaaa" password="122222" nome="asasas" sobrenome="aass" email="[email protected]" pais="SS" telefone="4002-" />

I would like to get the parameter and value separeted in split.

I try this:

xml.ToString().Replace(" =" , "=").Replace("= " , "=").Replace(" = " , "=").Split(new char[]{' '});

But not work perfect becase for example the attribute 'address' was split in two items

{string[29]}
[0]: "<signature"
[1]: "aaa=\"xxxx\""
[2]: "sss=\"xxxx\""
[3]: "ssss=\"xxx\""
[4]: "username=\"xxx\""
[5]: "password=\"xxxx\""
[6]: "nome=\"xxxx\""
[7]: "sobrenome=\"xxx\""
[8]: "email=\"[email protected]\""
[9]: "pais=\"BR\""
[10]: "endereco=\"Rua"
[11]: "Sao"
[12]: "Carlos,"
[13]: "128\""
[14]: "cidade=\"Sao"
[15]: "Paulo\""

The error is

   [10]: "endereco=\"Rua"
[11]: "Sao"
[12]: "Carlos,"

When the correct I would like is

[10]: "endereco=\"Rua Sao Carlos , 128"

That is correct because the address is separtated by ' ' and u wanted to split with ' ' — Dan Hunex
– Dan Hunex, Commented Dec 17, 2013 at 22:52
Can you just rename the duplicate attribute and then parse as well-formatted XML? — D Stanley
– D Stanley, Commented Dec 17, 2013 at 22:55
Not becase this xml is diferent in some times. And not have one xml pattern,(one schemma) — Rodrigo Porcionato
– Rodrigo Porcionato, Commented Dec 17, 2013 at 22:56
Yes, It is create from another company that's not know the 'schemma xml'. — Rodrigo Porcionato
– Rodrigo Porcionato, Commented Dec 17, 2013 at 22:58

AFrieze · Accepted Answer · 2013-12-17 23:16:56Z

1

A regular expression will work for this as you are working with badly formed xml.

        Regex regex = new Regex("\\s\\w+=\"(\\w|\\s|,|=|@|-|\\.)+\"");
        MatchCollection matches = regex.Matches(searchText);
        foreach (var match in matches)
        {
          //your code here
        }

Tested with your example string and matches were as expected. Hope this Helps!

answered Dec 17, 2013 at 23:16

AFrieze

8741 gold badge11 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

crthompson Over a year ago

Given that he is working with junk xml, this is the best choice. +1 Hope he can get good xml tho, then XDocument is the way to go.

AFrieze Over a year ago

thanks, and I agree that the best result would be to have good xml.

Rodrigo Porcionato Over a year ago

Hi, your solution it's work perfect AFrieze! I agree it's the best Approach! thank you very much!

AFrieze Over a year ago

Glad it helped! Mark as answer? :) (green checkbox)

Dan Hunex · Accepted Answer · 2013-12-17 22:55:18Z

0

I would suggest you to use xPath or Linq to parse this xml. The way you are using is not a good way and that is why you end up in error."Rua Sao Carlo" contains three words separated by single space ; as a result when you try to split it with single space, it also splits the address

answered Dec 17, 2013 at 22:55

Dan Hunex

5,3182 gold badges31 silver badges43 bronze badges

2 Comments

D Stanley Over a year ago

There are multiple telefone attributes so it is not well-formed XML.

Rodrigo Porcionato Over a year ago

I know that is not well-formed . Becase this is a STRING and not have one "schema xml".

CDspace · Accepted Answer · 2013-12-17 23:18:44Z

0

Try this overload of Split. It will allow you to use a string as the splitter token, namely '" ' (that is quote and space). This will split to the name and attribute pairs. Then take the resulting array, and split it again on = (equals) to get the pairs you need, then do as you will with them. Hope this gets you headed in the right direction

answered Dec 17, 2013 at 23:18

CDspace

2,69919 gold badges32 silver badges39 bronze badges

Comments

crthompson · Accepted Answer · 2013-12-17 23:24:56Z

As already noted, you have badly formed XML. If you were to fix it, by either renaming or removing on of the telephone attributes, you could break down your XML like this:

This is the correct way to handle the XML, if however you do not have control over getting proper xml and must work w/ junk, i'd suggest the regex answer by @AFrieze.

var xmlString = @"<MYXML address=""rua sao carlos, 128"" service=""xxxxxx"" source=""xxxxxxx"" username=""aaaaaaa"" password=""122222"" nome=""asasas"" sobrenome=""aass"" email=""[email protected]"" pais=""SS"" telefone=""4002-"" />";
var xml = XDocument.Parse(xmlString);
var values = xml.Descendants("MYXML").SelectMany(x => x.Attributes()).ToArray();

foreach (var value in values)
{
    Console.WriteLine(value);
}
Console.Read();

This returns:

address="rua sao carlos, 128"
service="xxxxxx"
source="xxxxxxx"
username="aaaaaaa"
password="122222"
nome="asasas"
sobrenome="aass"
email="[email protected]"
pais="SS"
telefone="4002-"

Collectives™ on Stack Overflow

split field/value from xml STRING not formatted

4 Answers 4

4 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related