search

MikeStall / DataTable

Class library for working with tabular data, especially CSV files
Apache License 2.0
150 stars 63 forks source link

Quotes escaping #8

Closed divan-9 closed 11 years ago

divan-9 commented 11 years ago

When I write CSV file, I expect that quotes are escaped, but they're not. It leads to situation when result file is unreadable by CsvReader.

NUnit test to demonstrate expected behavior

var dt = DataTable.New.FromTuple(new[] { Tuple.Create("1", "XXX\"XXX") }, "A", "B");

            var sb = new StringBuilder();
            var writer = new StringWriter(sb);
            dt.SaveToStream(writer);

            NUnit.Framework.Assert.That(sb.ToString(), Is.EqualTo("A,B\r\n1,XXX\"\"XXX"));