Reading the string from a txt file and converting it to elements in xml using c#

Question

I have a string like this { {Name Mike} {age 19} {gender male}} in a txt file. I would like this to be converted to xml as the below output. As i am new to this, it seems to be pretty doubts for me.

<name>Mike</name>
<age>19</age>
<gender>male</male>

any help would be appreciated.

That's not any common markup, though it is somewhat close to json. You'll have to parse it yourself and build up your xml document. — Jonesopolis
– Jonesopolis, Commented Apr 13, 2016 at 0:30
You could use something like this "stackoverflow.com/questions/7771500/…" — Firoz
– Firoz, Commented Apr 13, 2016 at 0:49
Thanks. But i would like the "Name" become the attribute and "Mike" should be the value for it. — stackdoubt
– stackdoubt, Commented Apr 13, 2016 at 1:02

Mostafiz · Accepted Answer · 2016-04-13 11:17:21Z

0

Here is my solution, at first you have to create a xml file in my case I have created x.xml at my bin folder and must create a root elemnt on the xml file, in my case sample xml at the begening as below, root element name can be anything, I have used just root

<root>
</root>

then code for writting you string as below

            string s = "{{Name Mike} {age 19} {gender male}}";
            string[] s2 = s.Replace("{", "").Replace("}", "").Split(' ');
            for (int i = 0; i < s2.Length; i++)
            {

                XDocument doc = XDocument.Load("x.xml");
                XElement rt = doc.Element("root");
                XElement elm = rt.Element(s2[i]);

                if (elm != null)
                {
                    elm.SetValue(s2[i + 1]);
                }
                else
                {
                    XElement x = new XElement(s2[i], s2[i + 1]);
                    rt.Add(x);
                }

                doc.Save("x.xml");
                i++;
            }

hope this will solve your problem

Update

if you want to automate file creation without creating the xml file by hand then you can do this way

            string s = "{{Name Mike} {age 19} {gender male}}";
            string[] s2 = s.Replace("{", "").Replace("}", "").Split(' ');

            if (!File.Exists("x.xml"))
            {
                TextWriter tw = new StreamWriter("x.xml", true);
                tw.WriteLine("<root>\n</root>");
                tw.Close();
            }

            for (int i = 0; i < s2.Length; i++)
            {

                XDocument doc = XDocument.Load("x.xml");
                XElement rt = doc.Element("root");
                XElement elm = rt.Element(s2[i]);

                if (elm != null)
                {
                    elm.SetValue(s2[i + 1]);
                }
                else
                {
                    XElement x = new XElement(s2[i], s2[i + 1]);
                    rt.Add(x);
                }

                doc.Save("x.xml");
                i++;
            }

edited Apr 13, 2016 at 11:17

answered Apr 13, 2016 at 2:36

Mostafiz

7,3523 gold badges30 silver badges42 bronze badges

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

4 Comments

stackdoubt Over a year ago

Instead of manually creating an xml file and is there a way that it can be automated since this needs to be created as an installer file.

Mostafiz Over a year ago

please see my answer update for that, the xml file will be created automatically if not present

stackdoubt Over a year ago

actually i am doing like this string s = @"E:\Newfolder\sample.txt"; but it hits an exception on XElement elm = rt.Element(s2[i]); "The ':' character, hexadecimal value 0x3A, cannot be included in a name."

Mostafiz Over a year ago

ok in your string there is a extra space at begin { {Name Mike} {age 19} {gender male}} after first bracket but my one not {{Name Mike} {age 19} {gender male}} problem is there, is it possible to format string as a consitence way like mine ? if not then you have to ignore that

Collectives™ on Stack Overflow

Reading the string from a txt file and converting it to elements in xml using c#

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related