.NET
Microsoft Technologies based on the .NET software framework.
3,363 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I got a problem with Linq while using select to read out fields from a csv file.
The program should read out the csv file and write it as a xml file in a specific form.
I cannot get it to work the way i like.
string[] source = File.ReadAllLines(@"PathTo.CSV");
XElement order = new XElement("ORDER",
from str in source
let fields = str.Split(';')
select new XElement("NOTTHIS",
new XElement("ORDERNUMBER", fields[0]),
new XElement("ORDERDATE", fields[10]),
new XElement("ORDERMARK", fields[15]),
new XElement("CUSTOMER",
new XElement("FIRSTNAME", fields[3]),
...
new XElement("TELEPHONE", fields[9])
)
)
);
order.Save(FileName);
So this is the code that works. It produces this structure in the output file:
<ORDER>
<NOT-THIS>
<ORDERNUMBER>A</ORDERNUMBER>
<ORDERDATE>B</ORDERDATE>
<ORDERMARK>C</ORDERMARK>
<CUSTOMER>
<FIRSTNAME>D</FIRSTNAME>
<TELEPHONE>E</TELEPHONE>
</CUSTOMER>
</NOT-THIS>
</ORDER>
But the Structure i want is this:
<ORDER>
<ORDERNUMBER>A</ORDERNUMBER>
<ORDERDATE>B</ORDERDATE>
<ORDERMARK>C</ORDERMARK>
<CUSTOMER>
<FIRSTNAME>D</FIRSTNAME>
<TELEPHONE>E</TELEPHONE>
</CUSTOMER>
</ORDER>
how can i get rid of the NOT-THIS while still being able to use select and fields[] ?