summaryrefslogtreecommitdiff
path: root/ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs
diff options
context:
space:
mode:
Diffstat (limited to 'ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs')
-rw-r--r--ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs1206
1 files changed, 1206 insertions, 0 deletions
diff --git a/ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs b/ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs
new file mode 100644
index 0000000..a4a4370
--- /dev/null
+++ b/ThirdParty/CsvHelper-master/tests/CsvHelper.Tests/Parsing/TrimTests.cs
@@ -0,0 +1,1206 @@
+// Copyright 2009-2022 Josh Close
+// This file is a part of CsvHelper and is dual licensed under MS-PL and Apache 2.0.
+// See LICENSE.txt for details or visit http://www.opensource.org/licenses/ms-pl.html for MS-PL and http://opensource.org/licenses/Apache-2.0 for Apache 2.0.
+// https://github.com/JoshClose/CsvHelper
+using CsvHelper.Configuration;
+using Xunit;
+using System.Globalization;
+using System.IO;
+using System.Linq;
+
+namespace CsvHelper.Tests.Parsing
+{
+
+ public class TrimTests
+ {
+ [Fact]
+ public void OutsideStartTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a,b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideStartNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideStartSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c,d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideStartSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c,d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideEndTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "a ,b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideEndNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "a ,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideEndSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "a b c ,d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideEndSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "a b c ,d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideBothTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a ,b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideBothNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a ,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideBothSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c ,d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideBothSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c ,d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesStartTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a\",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesStartNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a\",b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesStartSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a b c\",d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesStartSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a b c\",d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesEndTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a\" ,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesEndNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a\" ,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesEndSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a b c\" ,d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesEndSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a b c\" ,d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a\" ,b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a\" ,b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a b c\" ,d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \"a b c\" ,d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothSpacesInFieldMultipleRecordsTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c , d e f \r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesBothSpacesInFieldMultipleRecordsNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " a b c , d e f ";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a\",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a\",b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c\",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c\",b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartSpacesInFieldDelimiterInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a ,b c\",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a ,b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesStartSpacesInFieldDelimiterInFieldSmallBufferNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ BufferSize = 1,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a ,b c\",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a ,b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesEndTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a \",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesEndNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a \",b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesEndSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a b c \",d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesEndSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\"a b c \",d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a \",b\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a \",b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesInFieldTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c \",d\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c \",d";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesInFieldMultipleRecordsTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c \",\" d e f \"\r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesInFieldMultipleRecordsNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "\" a b c \",\" d e f \"";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideAndInsideQuotesTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim | TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \" a b c \" , \" d e f \" \r\n";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideAndInsideQuotesNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim | TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = " \" a b c \" , \" d e f \" ";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b c", parser[0]);
+ Assert.Equal("d e f", parser[1]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesNoSpacesNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "abc";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("abc", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void OutsideQuotesNoSpacesHasSpaceInFieldNoNewlineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var parser = new CsvParser(reader, config))
+ {
+ var line = "a b";
+ writer.Write(line);
+ writer.Flush();
+ stream.Position = 0;
+
+ parser.Read();
+
+ Assert.Equal("a b", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideNoSpacesQuotesFieldHasEscapedQuotesTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ var line = "\"a \"\"b\"\" c\"";
+ using (var reader = new StringReader(line))
+ using (var parser = new CsvParser(reader, config))
+ {
+ parser.Read();
+
+ Assert.Equal("a \"b\" c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesFieldHasEscapedQuotesTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ var line = "\" a \"\"b\"\" c \"\r\n";
+ using (var reader = new StringReader(line))
+ using (var parser = new CsvParser(reader, config))
+ {
+ parser.Read();
+
+ Assert.Equal("a \"b\" c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void InsideQuotesBothSpacesFieldHasEscapedQuotesNoNewLineTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.InsideQuotes,
+ };
+ var line = "\" a \"\"b\"\" c \"";
+ using (var reader = new StringReader(line))
+ using (var parser = new CsvParser(reader, config))
+ {
+ parser.Read();
+
+ Assert.Equal("a \"b\" c", parser[0]);
+ Assert.Equal(line, parser.RawRecord.ToString());
+ }
+ }
+
+ [Fact]
+ public void ReadingTest()
+ {
+ var config = new CsvConfiguration(CultureInfo.InvariantCulture)
+ {
+ TrimOptions = TrimOptions.Trim | TrimOptions.InsideQuotes,
+ };
+ using (var stream = new MemoryStream())
+ using (var writer = new StreamWriter(stream))
+ using (var reader = new StreamReader(stream))
+ using (var csv = new CsvReader(reader, config))
+ {
+ writer.WriteLine("A,B");
+ writer.WriteLine(" \" a b c \" , \" d e f \" ");
+ writer.Flush();
+ stream.Position = 0;
+
+ var records = csv.GetRecords<dynamic>().ToList();
+
+ var record = records[0];
+ Assert.Equal("a b c", record.A);
+ Assert.Equal("d e f", record.B);
+ }
+ }
+ }
+}