Turn Csv File Into Xml Notepad

Online XML To CSV or Plain. The Source Data box will turn into a graphical XML viewer and your XML data will. License Mtkey Vita Scene Update. Choose the target file format, CSV. This example converts meta-tagged XML into CSV with all fields quoted xml version='1.0' encoding='UTF-8'?>notepad>convert an XML file. ., rename many files using expressions, copy part of a file, change times of a file, delete files in selected sub folders, set file time from filename, print colored text to terminal, convert csv to tab separated, download files from web, send http or udp requests, print tcp or udp traffic, create hexdump of files, join many text files into one.

I need to Convert a CSV into an XML document. The examples I have seen so far, all show how to do this with a fixed number of columns in the CSV. I have this so far, using LINQ: String[] File = File.ReadAllLines(@'C: text.csv'); String xml = '; XElement top = new XElement('TopElement', from items in File let fields = items.Split(';') select new XElement('Item', new XElement('Column1', fields[0]), new XElement('Column2', fields[1]), new XElement('Column3', fields[2]), new XElement('Column4', fields[3]), new XElement('Column5', fields[4]) ) ); File.WriteAllText(@'C: xmlout.xml', xml + top.ToString()); This is for a fixed amount of columns, but my.CSV has a different number of columns on each line. How would you fit some sort of loop into this, depending on how many words (columns) there are in each line of the.CSV? Var lines = File.ReadAllLines(@'C: text.csv'); var xml = new XElement('TopElement', lines.Select(line =>new XElement('Item', line.Split(';').Select((column, index) =>new XElement('Column' + index, column))))); xml.Save(@'C: xmlout.xml'); Input: A;B;C D;E;F G;H Output: A B C D E F G H. Pretty close. But I need to split eveery word on each line seperated by a; So, the output XML would look something like this: word word word word word word word I almost had it with the code I posted, but I only got the first word in each line.

So I need to add some sort of loop, that adds a Column element for each word on each line seperated by a; – Jun 18 '10 at 13:13 •.