You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@commons.apache.org by br...@apache.org on 2014/05/04 19:25:34 UTC
svn commit: r908013 [15/22] - in
/websites/production/commons/content/proper/commons-csv: ./ apidocs/
apidocs/org/apache/commons/csv/ apidocs/org/apache/commons/csv/class-use/
apidocs/src-html/org/apache/commons/csv/ testapidocs/
testapidocs/org/apache...
Modified: websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVParserTest.html
==============================================================================
--- websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVParserTest.html (original)
+++ websites/production/commons/content/proper/commons-csv/xref-test/org/apache/commons/csv/CSVParserTest.html Sun May 4 17:25:32 2014
@@ -38,784 +38,899 @@
<a class="jxr_linenumber" name="L30" href="#L30">30</a>
<a class="jxr_linenumber" name="L31" href="#L31">31</a> <strong class="jxr_keyword">import</strong> java.io.File;
<a class="jxr_linenumber" name="L32" href="#L32">32</a> <strong class="jxr_keyword">import</strong> java.io.IOException;
-<a class="jxr_linenumber" name="L33" href="#L33">33</a> <strong class="jxr_keyword">import</strong> java.io.Reader;
-<a class="jxr_linenumber" name="L34" href="#L34">34</a> <strong class="jxr_keyword">import</strong> java.io.StringReader;
-<a class="jxr_linenumber" name="L35" href="#L35">35</a> <strong class="jxr_keyword">import</strong> java.io.StringWriter;
-<a class="jxr_linenumber" name="L36" href="#L36">36</a> <strong class="jxr_keyword">import</strong> java.net.URL;
-<a class="jxr_linenumber" name="L37" href="#L37">37</a> <strong class="jxr_keyword">import</strong> java.nio.charset.Charset;
-<a class="jxr_linenumber" name="L38" href="#L38">38</a> <strong class="jxr_keyword">import</strong> java.util.ArrayList;
-<a class="jxr_linenumber" name="L39" href="#L39">39</a> <strong class="jxr_keyword">import</strong> java.util.Iterator;
-<a class="jxr_linenumber" name="L40" href="#L40">40</a> <strong class="jxr_keyword">import</strong> java.util.List;
-<a class="jxr_linenumber" name="L41" href="#L41">41</a> <strong class="jxr_keyword">import</strong> java.util.Map;
-<a class="jxr_linenumber" name="L42" href="#L42">42</a> <strong class="jxr_keyword">import</strong> java.util.NoSuchElementException;
-<a class="jxr_linenumber" name="L43" href="#L43">43</a>
-<a class="jxr_linenumber" name="L44" href="#L44">44</a> <strong class="jxr_keyword">import</strong> org.junit.Assert;
-<a class="jxr_linenumber" name="L45" href="#L45">45</a> <strong class="jxr_keyword">import</strong> org.junit.Ignore;
-<a class="jxr_linenumber" name="L46" href="#L46">46</a> <strong class="jxr_keyword">import</strong> org.junit.Test;
+<a class="jxr_linenumber" name="L33" href="#L33">33</a> <strong class="jxr_keyword">import</strong> java.io.InputStreamReader;
+<a class="jxr_linenumber" name="L34" href="#L34">34</a> <strong class="jxr_keyword">import</strong> java.io.PipedReader;
+<a class="jxr_linenumber" name="L35" href="#L35">35</a> <strong class="jxr_keyword">import</strong> java.io.PipedWriter;
+<a class="jxr_linenumber" name="L36" href="#L36">36</a> <strong class="jxr_keyword">import</strong> java.io.Reader;
+<a class="jxr_linenumber" name="L37" href="#L37">37</a> <strong class="jxr_keyword">import</strong> java.io.StringReader;
+<a class="jxr_linenumber" name="L38" href="#L38">38</a> <strong class="jxr_keyword">import</strong> java.io.StringWriter;
+<a class="jxr_linenumber" name="L39" href="#L39">39</a> <strong class="jxr_keyword">import</strong> java.net.URL;
+<a class="jxr_linenumber" name="L40" href="#L40">40</a> <strong class="jxr_keyword">import</strong> java.nio.charset.Charset;
+<a class="jxr_linenumber" name="L41" href="#L41">41</a> <strong class="jxr_keyword">import</strong> java.util.ArrayList;
+<a class="jxr_linenumber" name="L42" href="#L42">42</a> <strong class="jxr_keyword">import</strong> java.util.Iterator;
+<a class="jxr_linenumber" name="L43" href="#L43">43</a> <strong class="jxr_keyword">import</strong> java.util.LinkedList;
+<a class="jxr_linenumber" name="L44" href="#L44">44</a> <strong class="jxr_keyword">import</strong> java.util.List;
+<a class="jxr_linenumber" name="L45" href="#L45">45</a> <strong class="jxr_keyword">import</strong> java.util.Map;
+<a class="jxr_linenumber" name="L46" href="#L46">46</a> <strong class="jxr_keyword">import</strong> java.util.NoSuchElementException;
<a class="jxr_linenumber" name="L47" href="#L47">47</a>
-<a class="jxr_linenumber" name="L48" href="#L48">48</a> <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L49" href="#L49">49</a> <em class="jxr_javadoccomment"> * CSVParserTest</em>
-<a class="jxr_linenumber" name="L50" href="#L50">50</a> <em class="jxr_javadoccomment"> *</em>
-<a class="jxr_linenumber" name="L51" href="#L51">51</a> <em class="jxr_javadoccomment"> * The test are organized in three different sections:</em>
-<a class="jxr_linenumber" name="L52" href="#L52">52</a> <em class="jxr_javadoccomment"> * The 'setter/getter' section, the lexer section and finally the parser</em>
-<a class="jxr_linenumber" name="L53" href="#L53">53</a> <em class="jxr_javadoccomment"> * section. In case a test fails, you should follow a top-down approach for</em>
-<a class="jxr_linenumber" name="L54" href="#L54">54</a> <em class="jxr_javadoccomment"> * fixing a potential bug (its likely that the parser itself fails if the lexer</em>
-<a class="jxr_linenumber" name="L55" href="#L55">55</a> <em class="jxr_javadoccomment"> * has problems...).</em>
-<a class="jxr_linenumber" name="L56" href="#L56">56</a> <em class="jxr_javadoccomment"> *</em>
-<a class="jxr_linenumber" name="L57" href="#L57">57</a> <em class="jxr_javadoccomment"> * @version $Id: CSVParserTest.java 1559908 2014-01-21 02:44:30Z ggregory $</em>
-<a class="jxr_linenumber" name="L58" href="#L58">58</a> <em class="jxr_javadoccomment"> */</em>
-<a class="jxr_linenumber" name="L59" href="#L59">59</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/apache/commons/csv/CSVParserTest.html">CSVParserTest</a> {
-<a class="jxr_linenumber" name="L60" href="#L60">60</a>
-<a class="jxr_linenumber" name="L61" href="#L61">61</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String CSVINPUT = <span class="jxr_string">"a,b,c,d\n"</span>
-<a class="jxr_linenumber" name="L62" href="#L62">62</a> + <span class="jxr_string">" a , b , 1 2 \n"</span>
-<a class="jxr_linenumber" name="L63" href="#L63">63</a> + <span class="jxr_string">"\"foo baar\", b,\n"</span>
-<a class="jxr_linenumber" name="L64" href="#L64">64</a> <em class="jxr_comment">// + " \"foo\n,,\n\"\",,\n\\\"\",d,e\n";</em>
-<a class="jxr_linenumber" name="L65" href="#L65">65</a> + <span class="jxr_string">" \"foo\n,,\n\"\",,\n\"\"\",d,e\n"</span>; <em class="jxr_comment">// changed to use standard CSV escaping</em>
-<a class="jxr_linenumber" name="L66" href="#L66">66</a>
-<a class="jxr_linenumber" name="L67" href="#L67">67</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String[][] RESULT = {
-<a class="jxr_linenumber" name="L68" href="#L68">68</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">"c"</span>, <span class="jxr_string">"d"</span>},
-<a class="jxr_linenumber" name="L69" href="#L69">69</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">"1 2"</span>},
-<a class="jxr_linenumber" name="L70" href="#L70">70</a> {<span class="jxr_string">"foo baar"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L71" href="#L71">71</a> {<span class="jxr_string">"foo\n,,\n\",,\n\""</span>, <span class="jxr_string">"d"</span>, <span class="jxr_string">"e"</span>}
-<a class="jxr_linenumber" name="L72" href="#L72">72</a> };
+<a class="jxr_linenumber" name="L48" href="#L48">48</a> <strong class="jxr_keyword">import</strong> org.apache.commons.io.input.BOMInputStream;
+<a class="jxr_linenumber" name="L49" href="#L49">49</a> <strong class="jxr_keyword">import</strong> org.junit.Assert;
+<a class="jxr_linenumber" name="L50" href="#L50">50</a> <strong class="jxr_keyword">import</strong> org.junit.Ignore;
+<a class="jxr_linenumber" name="L51" href="#L51">51</a> <strong class="jxr_keyword">import</strong> org.junit.Test;
+<a class="jxr_linenumber" name="L52" href="#L52">52</a>
+<a class="jxr_linenumber" name="L53" href="#L53">53</a> <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L54" href="#L54">54</a> <em class="jxr_javadoccomment"> * CSVParserTest</em>
+<a class="jxr_linenumber" name="L55" href="#L55">55</a> <em class="jxr_javadoccomment"> *</em>
+<a class="jxr_linenumber" name="L56" href="#L56">56</a> <em class="jxr_javadoccomment"> * The test are organized in three different sections:</em>
+<a class="jxr_linenumber" name="L57" href="#L57">57</a> <em class="jxr_javadoccomment"> * The 'setter/getter' section, the lexer section and finally the parser</em>
+<a class="jxr_linenumber" name="L58" href="#L58">58</a> <em class="jxr_javadoccomment"> * section. In case a test fails, you should follow a top-down approach for</em>
+<a class="jxr_linenumber" name="L59" href="#L59">59</a> <em class="jxr_javadoccomment"> * fixing a potential bug (its likely that the parser itself fails if the lexer</em>
+<a class="jxr_linenumber" name="L60" href="#L60">60</a> <em class="jxr_javadoccomment"> * has problems...).</em>
+<a class="jxr_linenumber" name="L61" href="#L61">61</a> <em class="jxr_javadoccomment"> *</em>
+<a class="jxr_linenumber" name="L62" href="#L62">62</a> <em class="jxr_javadoccomment"> * @version $Id: CSVParserTest.java 1592371 2014-05-04 16:22:34Z britter $</em>
+<a class="jxr_linenumber" name="L63" href="#L63">63</a> <em class="jxr_javadoccomment"> */</em>
+<a class="jxr_linenumber" name="L64" href="#L64">64</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/apache/commons/csv/CSVParserTest.html">CSVParserTest</a> {
+<a class="jxr_linenumber" name="L65" href="#L65">65</a>
+<a class="jxr_linenumber" name="L66" href="#L66">66</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String CSV_INPUT = <span class="jxr_string">"a,b,c,d\n"</span>
+<a class="jxr_linenumber" name="L67" href="#L67">67</a> + <span class="jxr_string">" a , b , 1 2 \n"</span>
+<a class="jxr_linenumber" name="L68" href="#L68">68</a> + <span class="jxr_string">"\"foo baar\", b,\n"</span>
+<a class="jxr_linenumber" name="L69" href="#L69">69</a> <em class="jxr_comment">// + " \"foo\n,,\n\"\",,\n\\\"\",d,e\n";</em>
+<a class="jxr_linenumber" name="L70" href="#L70">70</a> + <span class="jxr_string">" \"foo\n,,\n\"\",,\n\"\"\",d,e\n"</span>; <em class="jxr_comment">// changed to use standard CSV escaping</em>
+<a class="jxr_linenumber" name="L71" href="#L71">71</a>
+<a class="jxr_linenumber" name="L72" href="#L72">72</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String CSV_INPUT_1 = <span class="jxr_string">"a,b,c,d"</span>;
<a class="jxr_linenumber" name="L73" href="#L73">73</a>
-<a class="jxr_linenumber" name="L74" href="#L74">74</a> @Test
-<a class="jxr_linenumber" name="L75" href="#L75">75</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testGetLine() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L76" href="#L76">76</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(CSVINPUT, CSVFormat.DEFAULT.withIgnoreSurroundingSpaces(<strong class="jxr_keyword">true</strong>));
-<a class="jxr_linenumber" name="L77" href="#L77">77</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String[] re : RESULT) {
-<a class="jxr_linenumber" name="L78" href="#L78">78</a> assertArrayEquals(re, parser.nextRecord().values());
-<a class="jxr_linenumber" name="L79" href="#L79">79</a> }
-<a class="jxr_linenumber" name="L80" href="#L80">80</a>
-<a class="jxr_linenumber" name="L81" href="#L81">81</a> assertNull(parser.nextRecord());
-<a class="jxr_linenumber" name="L82" href="#L82">82</a> }
-<a class="jxr_linenumber" name="L83" href="#L83">83</a>
-<a class="jxr_linenumber" name="L84" href="#L84">84</a> @Test
-<a class="jxr_linenumber" name="L85" href="#L85">85</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testGetRecords() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L86" href="#L86">86</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(CSVINPUT, CSVFormat.DEFAULT.withIgnoreSurroundingSpaces(<strong class="jxr_keyword">true</strong>));
-<a class="jxr_linenumber" name="L87" href="#L87">87</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L88" href="#L88">88</a> assertEquals(RESULT.length, records.size());
-<a class="jxr_linenumber" name="L89" href="#L89">89</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L90" href="#L90">90</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < RESULT.length; i++) {
-<a class="jxr_linenumber" name="L91" href="#L91">91</a> assertArrayEquals(RESULT[i], records.get(i).values());
-<a class="jxr_linenumber" name="L92" href="#L92">92</a> }
-<a class="jxr_linenumber" name="L93" href="#L93">93</a> }
-<a class="jxr_linenumber" name="L94" href="#L94">94</a>
-<a class="jxr_linenumber" name="L95" href="#L95">95</a> @Test
-<a class="jxr_linenumber" name="L96" href="#L96">96</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelFormat1() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L97" href="#L97">97</a> <strong class="jxr_keyword">final</strong> String code =
-<a class="jxr_linenumber" name="L98" href="#L98">98</a> <span class="jxr_string">"value1,value2,value3,value4\r\na,b,c,d\r\n x,,,"</span>
-<a class="jxr_linenumber" name="L99" href="#L99">99</a> + <span class="jxr_string">"\r\n\r\n\"\"\"hello\"\"\",\" \"\"world\"\"\",\"abc\ndef\",\r\n"</span>;
-<a class="jxr_linenumber" name="L100" href="#L100">100</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L101" href="#L101">101</a> {<span class="jxr_string">"value1"</span>, <span class="jxr_string">"value2"</span>, <span class="jxr_string">"value3"</span>, <span class="jxr_string">"value4"</span>},
-<a class="jxr_linenumber" name="L102" href="#L102">102</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">"c"</span>, <span class="jxr_string">"d"</span>},
-<a class="jxr_linenumber" name="L103" href="#L103">103</a> {<span class="jxr_string">" x"</span>, <span class="jxr_string">""</span>, <span class="jxr_string">""</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L104" href="#L104">104</a> {<span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L105" href="#L105">105</a> {<span class="jxr_string">"\"hello\""</span>, <span class="jxr_string">" \"world\""</span>, <span class="jxr_string">"abc\ndef"</span>, <span class="jxr_string">""</span>}
-<a class="jxr_linenumber" name="L106" href="#L106">106</a> };
-<a class="jxr_linenumber" name="L107" href="#L107">107</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="L108" href="#L108">108</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L109" href="#L109">109</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L110" href="#L110">110</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L111" href="#L111">111</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L112" href="#L112">112</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L113" href="#L113">113</a> }
-<a class="jxr_linenumber" name="L114" href="#L114">114</a> }
+<a class="jxr_linenumber" name="L74" href="#L74">74</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String CSV_INPUT_2 = <span class="jxr_string">"a,b,1 2"</span>;
+<a class="jxr_linenumber" name="L75" href="#L75">75</a>
+<a class="jxr_linenumber" name="L76" href="#L76">76</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String[][] RESULT = {
+<a class="jxr_linenumber" name="L77" href="#L77">77</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">"c"</span>, <span class="jxr_string">"d"</span>},
+<a class="jxr_linenumber" name="L78" href="#L78">78</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">"1 2"</span>},
+<a class="jxr_linenumber" name="L79" href="#L79">79</a> {<span class="jxr_string">"foo baar"</span>, <span class="jxr_string">"b"</span>, <span class="jxr_string">""</span>},
+<a class="jxr_linenumber" name="L80" href="#L80">80</a> {<span class="jxr_string">"foo\n,,\n\",,\n\""</span>, <span class="jxr_string">"d"</span>, <span class="jxr_string">"e"</span>}
+<a class="jxr_linenumber" name="L81" href="#L81">81</a> };
+<a class="jxr_linenumber" name="L82" href="#L82">82</a>
+<a class="jxr_linenumber" name="L83" href="#L83">83</a> @Test
+<a class="jxr_linenumber" name="L84" href="#L84">84</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscaping() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L85" href="#L85">85</a>
+<a class="jxr_linenumber" name="L86" href="#L86">86</a> <em class="jxr_comment">// To avoid confusion over the need for escaping chars in java code,</em>
+<a class="jxr_linenumber" name="L87" href="#L87">87</a> <em class="jxr_comment">// We will test with a forward slash as the escape char, and a single</em>
+<a class="jxr_linenumber" name="L88" href="#L88">88</a> <em class="jxr_comment">// quote as the encapsulator.</em>
+<a class="jxr_linenumber" name="L89" href="#L89">89</a>
+<a class="jxr_linenumber" name="L90" href="#L90">90</a> <strong class="jxr_keyword">final</strong> String code =
+<a class="jxr_linenumber" name="L91" href="#L91">91</a> <span class="jxr_string">"one,two,three\n"</span> <em class="jxr_comment">// 0</em>
+<a class="jxr_linenumber" name="L92" href="#L92">92</a> + <span class="jxr_string">"'',''\n"</span> <em class="jxr_comment">// 1) empty encapsulators</em>
+<a class="jxr_linenumber" name="L93" href="#L93">93</a> + <span class="jxr_string">"/',/'\n"</span> <em class="jxr_comment">// 2) single encapsulators</em>
+<a class="jxr_linenumber" name="L94" href="#L94">94</a> + <span class="jxr_string">"'/'','/''\n"</span> <em class="jxr_comment">// 3) single encapsulators encapsulated via escape</em>
+<a class="jxr_linenumber" name="L95" href="#L95">95</a> + <span class="jxr_string">"'''',''''\n"</span> <em class="jxr_comment">// 4) single encapsulators encapsulated via doubling</em>
+<a class="jxr_linenumber" name="L96" href="#L96">96</a> + <span class="jxr_string">"/,,/,\n"</span> <em class="jxr_comment">// 5) separator escaped</em>
+<a class="jxr_linenumber" name="L97" href="#L97">97</a> + <span class="jxr_string">"//,//\n"</span> // 6) escape escaped
+<a class="jxr_linenumber" name="L98" href="#L98">98</a> + <span class="jxr_string">"'//','//'\n"</span> // 7) escape escaped in encapsulation
+<a class="jxr_linenumber" name="L99" href="#L99">99</a> + <span class="jxr_string">" 8 , \"quoted \"\" /\" // string\" \n"</span> // don't eat spaces
+<a class="jxr_linenumber" name="L100" href="#L100">100</a> + <span class="jxr_string">"9, /\n \n"</span> <em class="jxr_comment">// escaped newline</em>
+<a class="jxr_linenumber" name="L101" href="#L101">101</a> + <span class="jxr_string">""</span>;
+<a class="jxr_linenumber" name="L102" href="#L102">102</a> <strong class="jxr_keyword">final</strong> String[][] res = {
+<a class="jxr_linenumber" name="L103" href="#L103">103</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"three"</span>}, <em class="jxr_comment">// 0</em>
+<a class="jxr_linenumber" name="L104" href="#L104">104</a> {<span class="jxr_string">""</span>, <span class="jxr_string">""</span>}, <em class="jxr_comment">// 1</em>
+<a class="jxr_linenumber" name="L105" href="#L105">105</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 2</em>
+<a class="jxr_linenumber" name="L106" href="#L106">106</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 3</em>
+<a class="jxr_linenumber" name="L107" href="#L107">107</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 4</em>
+<a class="jxr_linenumber" name="L108" href="#L108">108</a> {<span class="jxr_string">","</span>, <span class="jxr_string">","</span>}, <em class="jxr_comment">// 5</em>
+<a class="jxr_linenumber" name="L109" href="#L109">109</a> {<span class="jxr_string">"/"</span>, <span class="jxr_string">"/"</span>}, <em class="jxr_comment">// 6</em>
+<a class="jxr_linenumber" name="L110" href="#L110">110</a> {<span class="jxr_string">"/"</span>, <span class="jxr_string">"/"</span>}, <em class="jxr_comment">// 7</em>
+<a class="jxr_linenumber" name="L111" href="#L111">111</a> {<span class="jxr_string">" 8 "</span>, <span class="jxr_string">" \"quoted \"\" /\" / string\" "</span>},
+<a class="jxr_linenumber" name="L112" href="#L112">112</a> {<span class="jxr_string">"9"</span>, <span class="jxr_string">" \n "</span>},
+<a class="jxr_linenumber" name="L113" href="#L113">113</a> };
+<a class="jxr_linenumber" name="L114" href="#L114">114</a>
<a class="jxr_linenumber" name="L115" href="#L115">115</a>
-<a class="jxr_linenumber" name="L116" href="#L116">116</a> @Test
-<a class="jxr_linenumber" name="L117" href="#L117">117</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testExcelFormat2() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L118" href="#L118">118</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">"foo,baar\r\n\r\nhello,\r\n\r\nworld,\r\n"</span>;
-<a class="jxr_linenumber" name="L119" href="#L119">119</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L120" href="#L120">120</a> {<span class="jxr_string">"foo"</span>, <span class="jxr_string">"baar"</span>},
-<a class="jxr_linenumber" name="L121" href="#L121">121</a> {<span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L122" href="#L122">122</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L123" href="#L123">123</a> {<span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L124" href="#L124">124</a> {<span class="jxr_string">"world"</span>, <span class="jxr_string">""</span>}
-<a class="jxr_linenumber" name="L125" href="#L125">125</a> };
-<a class="jxr_linenumber" name="L126" href="#L126">126</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="L127" href="#L127">127</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L128" href="#L128">128</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L129" href="#L129">129</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L130" href="#L130">130</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L131" href="#L131">131</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L132" href="#L132">132</a> }
-<a class="jxr_linenumber" name="L133" href="#L133">133</a> }
-<a class="jxr_linenumber" name="L134" href="#L134">134</a>
-<a class="jxr_linenumber" name="L135" href="#L135">135</a> @Test
-<a class="jxr_linenumber" name="L136" href="#L136">136</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEndOfFileBehaviourExcel() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L137" href="#L137">137</a> <strong class="jxr_keyword">final</strong> String[] codes = {
-<a class="jxr_linenumber" name="L138" href="#L138">138</a> <span class="jxr_string">"hello,\r\n\r\nworld,\r\n"</span>,
-<a class="jxr_linenumber" name="L139" href="#L139">139</a> <span class="jxr_string">"hello,\r\n\r\nworld,"</span>,
-<a class="jxr_linenumber" name="L140" href="#L140">140</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\"\r\n"</span>,
-<a class="jxr_linenumber" name="L141" href="#L141">141</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\""</span>,
-<a class="jxr_linenumber" name="L142" href="#L142">142</a> <span class="jxr_string">"hello,\r\n\r\nworld,\n"</span>,
-<a class="jxr_linenumber" name="L143" href="#L143">143</a> <span class="jxr_string">"hello,\r\n\r\nworld,"</span>,
-<a class="jxr_linenumber" name="L144" href="#L144">144</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\"\n"</span>,
-<a class="jxr_linenumber" name="L145" href="#L145">145</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\""</span>
-<a class="jxr_linenumber" name="L146" href="#L146">146</a> };
-<a class="jxr_linenumber" name="L147" href="#L147">147</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L148" href="#L148">148</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L149" href="#L149">149</a> {<span class="jxr_string">""</span>}, <em class="jxr_comment">// Excel format does not ignore empty lines</em>
-<a class="jxr_linenumber" name="L150" href="#L150">150</a> {<span class="jxr_string">"world"</span>, <span class="jxr_string">""</span>}
-<a class="jxr_linenumber" name="L151" href="#L151">151</a> };
+<a class="jxr_linenumber" name="L116" href="#L116">116</a> <strong class="jxr_keyword">final</strong> CSVFormat format = CSVFormat.newFormat(',').withQuoteChar('\'')
+<a class="jxr_linenumber" name="L117" href="#L117">117</a> .withRecordSeparator(CRLF).withEscape('/').withIgnoreEmptyLines(<strong class="jxr_keyword">true</strong>);
+<a class="jxr_linenumber" name="L118" href="#L118">118</a>
+<a class="jxr_linenumber" name="L119" href="#L119">119</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, format);
+<a class="jxr_linenumber" name="L120" href="#L120">120</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L121" href="#L121">121</a> assertTrue(records.size() > 0);
+<a class="jxr_linenumber" name="L122" href="#L122">122</a>
+<a class="jxr_linenumber" name="L123" href="#L123">123</a> Utils.compare(<span class="jxr_string">"Records do not match expected result"</span>, res, records);
+<a class="jxr_linenumber" name="L124" href="#L124">124</a> parser.close();
+<a class="jxr_linenumber" name="L125" href="#L125">125</a> }
+<a class="jxr_linenumber" name="L126" href="#L126">126</a>
+<a class="jxr_linenumber" name="L127" href="#L127">127</a> @Test
+<a class="jxr_linenumber" name="L128" href="#L128">128</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscaping2() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L129" href="#L129">129</a>
+<a class="jxr_linenumber" name="L130" href="#L130">130</a> <em class="jxr_comment">// To avoid confusion over the need for escaping chars in java code,</em>
+<a class="jxr_linenumber" name="L131" href="#L131">131</a> <em class="jxr_comment">// We will test with a forward slash as the escape char, and a single</em>
+<a class="jxr_linenumber" name="L132" href="#L132">132</a> <em class="jxr_comment">// quote as the encapsulator.</em>
+<a class="jxr_linenumber" name="L133" href="#L133">133</a>
+<a class="jxr_linenumber" name="L134" href="#L134">134</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">""</span>
+<a class="jxr_linenumber" name="L135" href="#L135">135</a> + <span class="jxr_string">" , , \n"</span> <em class="jxr_comment">// 1)</em>
+<a class="jxr_linenumber" name="L136" href="#L136">136</a> + <span class="jxr_string">" \t , , \n"</span> <em class="jxr_comment">// 2)</em>
+<a class="jxr_linenumber" name="L137" href="#L137">137</a> + <span class="jxr_string">" // , /, , /,\n"</span> // 3)
+<a class="jxr_linenumber" name="L138" href="#L138">138</a> + <span class="jxr_string">""</span>;
+<a class="jxr_linenumber" name="L139" href="#L139">139</a> <strong class="jxr_keyword">final</strong> String[][] res = {
+<a class="jxr_linenumber" name="L140" href="#L140">140</a> {<span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>}, <em class="jxr_comment">// 1</em>
+<a class="jxr_linenumber" name="L141" href="#L141">141</a> {<span class="jxr_string">" \t "</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>}, <em class="jxr_comment">// 2</em>
+<a class="jxr_linenumber" name="L142" href="#L142">142</a> {<span class="jxr_string">" / "</span>, <span class="jxr_string">" , "</span>, <span class="jxr_string">" ,"</span>}, <em class="jxr_comment">// 3</em>
+<a class="jxr_linenumber" name="L143" href="#L143">143</a> };
+<a class="jxr_linenumber" name="L144" href="#L144">144</a>
+<a class="jxr_linenumber" name="L145" href="#L145">145</a>
+<a class="jxr_linenumber" name="L146" href="#L146">146</a> <strong class="jxr_keyword">final</strong> CSVFormat format = CSVFormat.newFormat(',')
+<a class="jxr_linenumber" name="L147" href="#L147">147</a> .withRecordSeparator(CRLF).withEscape('/').withIgnoreEmptyLines(<strong class="jxr_keyword">true</strong>);
+<a class="jxr_linenumber" name="L148" href="#L148">148</a>
+<a class="jxr_linenumber" name="L149" href="#L149">149</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, format);
+<a class="jxr_linenumber" name="L150" href="#L150">150</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L151" href="#L151">151</a> assertTrue(records.size() > 0);
<a class="jxr_linenumber" name="L152" href="#L152">152</a>
-<a class="jxr_linenumber" name="L153" href="#L153">153</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String code : codes) {
-<a class="jxr_linenumber" name="L154" href="#L154">154</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="L155" href="#L155">155</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L156" href="#L156">156</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L157" href="#L157">157</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L158" href="#L158">158</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L159" href="#L159">159</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L160" href="#L160">160</a> }
-<a class="jxr_linenumber" name="L161" href="#L161">161</a> }
-<a class="jxr_linenumber" name="L162" href="#L162">162</a> }
-<a class="jxr_linenumber" name="L163" href="#L163">163</a>
-<a class="jxr_linenumber" name="L164" href="#L164">164</a> @Test
-<a class="jxr_linenumber" name="L165" href="#L165">165</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEndOfFileBehaviorCSV() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L166" href="#L166">166</a> <strong class="jxr_keyword">final</strong> String[] codes = {
-<a class="jxr_linenumber" name="L167" href="#L167">167</a> <span class="jxr_string">"hello,\r\n\r\nworld,\r\n"</span>,
-<a class="jxr_linenumber" name="L168" href="#L168">168</a> <span class="jxr_string">"hello,\r\n\r\nworld,"</span>,
-<a class="jxr_linenumber" name="L169" href="#L169">169</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\"\r\n"</span>,
-<a class="jxr_linenumber" name="L170" href="#L170">170</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\""</span>,
-<a class="jxr_linenumber" name="L171" href="#L171">171</a> <span class="jxr_string">"hello,\r\n\r\nworld,\n"</span>,
-<a class="jxr_linenumber" name="L172" href="#L172">172</a> <span class="jxr_string">"hello,\r\n\r\nworld,"</span>,
-<a class="jxr_linenumber" name="L173" href="#L173">173</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\"\n"</span>,
-<a class="jxr_linenumber" name="L174" href="#L174">174</a> <span class="jxr_string">"hello,\r\n\r\nworld,\"\""</span>
-<a class="jxr_linenumber" name="L175" href="#L175">175</a> };
-<a class="jxr_linenumber" name="L176" href="#L176">176</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L177" href="#L177">177</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>}, <em class="jxr_comment">// CSV format ignores empty lines</em>
-<a class="jxr_linenumber" name="L178" href="#L178">178</a> {<span class="jxr_string">"world"</span>, <span class="jxr_string">""</span>}
-<a class="jxr_linenumber" name="L179" href="#L179">179</a> };
-<a class="jxr_linenumber" name="L180" href="#L180">180</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String code : codes) {
-<a class="jxr_linenumber" name="L181" href="#L181">181</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L182" href="#L182">182</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L183" href="#L183">183</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L184" href="#L184">184</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L185" href="#L185">185</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L186" href="#L186">186</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L187" href="#L187">187</a> }
-<a class="jxr_linenumber" name="L188" href="#L188">188</a> }
+<a class="jxr_linenumber" name="L153" href="#L153">153</a> Utils.compare(<span class="jxr_string">""</span>, res, records);
+<a class="jxr_linenumber" name="L154" href="#L154">154</a> parser.close();
+<a class="jxr_linenumber" name="L155" href="#L155">155</a> }
+<a class="jxr_linenumber" name="L156" href="#L156">156</a>
+<a class="jxr_linenumber" name="L157" href="#L157">157</a> @Test
+<a class="jxr_linenumber" name="L158" href="#L158">158</a> @Ignore
+<a class="jxr_linenumber" name="L159" href="#L159">159</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscapingOld() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L160" href="#L160">160</a> <strong class="jxr_keyword">final</strong> String code =
+<a class="jxr_linenumber" name="L161" href="#L161">161</a> <span class="jxr_string">"one,two,three\n"</span>
+<a class="jxr_linenumber" name="L162" href="#L162">162</a> + <span class="jxr_string">"on\\\"e,two\n"</span>
+<a class="jxr_linenumber" name="L163" href="#L163">163</a> + <span class="jxr_string">"on\"e,two\n"</span>
+<a class="jxr_linenumber" name="L164" href="#L164">164</a> + <span class="jxr_string">"one,\"tw\\\"o\"\n"</span>
+<a class="jxr_linenumber" name="L165" href="#L165">165</a> + <span class="jxr_string">"one,\"t\\,wo\"\n"</span>
+<a class="jxr_linenumber" name="L166" href="#L166">166</a> + <span class="jxr_string">"one,two,\"th,ree\"\n"</span>
+<a class="jxr_linenumber" name="L167" href="#L167">167</a> + <span class="jxr_string">"\"a\\\\\"\n"</span>
+<a class="jxr_linenumber" name="L168" href="#L168">168</a> + <span class="jxr_string">"a\\,b\n"</span>
+<a class="jxr_linenumber" name="L169" href="#L169">169</a> + <span class="jxr_string">"\"a\\\\,b\""</span>;
+<a class="jxr_linenumber" name="L170" href="#L170">170</a> <strong class="jxr_keyword">final</strong> String[][] res = {
+<a class="jxr_linenumber" name="L171" href="#L171">171</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"three"</span>},
+<a class="jxr_linenumber" name="L172" href="#L172">172</a> {<span class="jxr_string">"on\\\"e"</span>, <span class="jxr_string">"two"</span>},
+<a class="jxr_linenumber" name="L173" href="#L173">173</a> {<span class="jxr_string">"on\"e"</span>, <span class="jxr_string">"two"</span>},
+<a class="jxr_linenumber" name="L174" href="#L174">174</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"tw\"o"</span>},
+<a class="jxr_linenumber" name="L175" href="#L175">175</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"t\\,wo"</span>}, <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
+<a class="jxr_linenumber" name="L176" href="#L176">176</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"th,ree"</span>},
+<a class="jxr_linenumber" name="L177" href="#L177">177</a> {<span class="jxr_string">"a\\\\"</span>}, <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
+<a class="jxr_linenumber" name="L178" href="#L178">178</a> {<span class="jxr_string">"a\\"</span>, <span class="jxr_string">"b"</span>}, <em class="jxr_comment">// a backslash must be returnd</em>
+<a class="jxr_linenumber" name="L179" href="#L179">179</a> {<span class="jxr_string">"a\\\\,b"</span>} <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
+<a class="jxr_linenumber" name="L180" href="#L180">180</a> };
+<a class="jxr_linenumber" name="L181" href="#L181">181</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L182" href="#L182">182</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L183" href="#L183">183</a> assertEquals(res.length, records.size());
+<a class="jxr_linenumber" name="L184" href="#L184">184</a> assertTrue(records.size() > 0);
+<a class="jxr_linenumber" name="L185" href="#L185">185</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
+<a class="jxr_linenumber" name="L186" href="#L186">186</a> assertArrayEquals(res[i], records.get(i).values());
+<a class="jxr_linenumber" name="L187" href="#L187">187</a> }
+<a class="jxr_linenumber" name="L188" href="#L188">188</a> parser.close();
<a class="jxr_linenumber" name="L189" href="#L189">189</a> }
<a class="jxr_linenumber" name="L190" href="#L190">190</a>
<a class="jxr_linenumber" name="L191" href="#L191">191</a> @Test
-<a class="jxr_linenumber" name="L192" href="#L192">192</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEmptyLineBehaviourExcel() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L193" href="#L193">193</a> <strong class="jxr_keyword">final</strong> String[] codes = {
-<a class="jxr_linenumber" name="L194" href="#L194">194</a> <span class="jxr_string">"hello,\r\n\r\n\r\n"</span>,
-<a class="jxr_linenumber" name="L195" href="#L195">195</a> <span class="jxr_string">"hello,\n\n\n"</span>,
-<a class="jxr_linenumber" name="L196" href="#L196">196</a> <span class="jxr_string">"hello,\"\"\r\n\r\n\r\n"</span>,
-<a class="jxr_linenumber" name="L197" href="#L197">197</a> <span class="jxr_string">"hello,\"\"\n\n\n"</span>
-<a class="jxr_linenumber" name="L198" href="#L198">198</a> };
-<a class="jxr_linenumber" name="L199" href="#L199">199</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L200" href="#L200">200</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L201" href="#L201">201</a> {<span class="jxr_string">""</span>}, <em class="jxr_comment">// Excel format does not ignore empty lines</em>
-<a class="jxr_linenumber" name="L202" href="#L202">202</a> {<span class="jxr_string">""</span>}
-<a class="jxr_linenumber" name="L203" href="#L203">203</a> };
-<a class="jxr_linenumber" name="L204" href="#L204">204</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String code : codes) {
-<a class="jxr_linenumber" name="L205" href="#L205">205</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.EXCEL);
-<a class="jxr_linenumber" name="L206" href="#L206">206</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L207" href="#L207">207</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L208" href="#L208">208</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L209" href="#L209">209</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L210" href="#L210">210</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L211" href="#L211">211</a> }
-<a class="jxr_linenumber" name="L212" href="#L212">212</a> }
-<a class="jxr_linenumber" name="L213" href="#L213">213</a> }
-<a class="jxr_linenumber" name="L214" href="#L214">214</a>
-<a class="jxr_linenumber" name="L215" href="#L215">215</a> @Test
-<a class="jxr_linenumber" name="L216" href="#L216">216</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEmptyLineBehaviourCSV() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L217" href="#L217">217</a> <strong class="jxr_keyword">final</strong> String[] codes = {
-<a class="jxr_linenumber" name="L218" href="#L218">218</a> <span class="jxr_string">"hello,\r\n\r\n\r\n"</span>,
-<a class="jxr_linenumber" name="L219" href="#L219">219</a> <span class="jxr_string">"hello,\n\n\n"</span>,
-<a class="jxr_linenumber" name="L220" href="#L220">220</a> <span class="jxr_string">"hello,\"\"\r\n\r\n\r\n"</span>,
-<a class="jxr_linenumber" name="L221" href="#L221">221</a> <span class="jxr_string">"hello,\"\"\n\n\n"</span>
-<a class="jxr_linenumber" name="L222" href="#L222">222</a> };
-<a class="jxr_linenumber" name="L223" href="#L223">223</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L224" href="#L224">224</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>} <em class="jxr_comment">// CSV format ignores empty lines</em>
-<a class="jxr_linenumber" name="L225" href="#L225">225</a> };
-<a class="jxr_linenumber" name="L226" href="#L226">226</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String code : codes) {
-<a class="jxr_linenumber" name="L227" href="#L227">227</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L228" href="#L228">228</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L229" href="#L229">229</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L230" href="#L230">230</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L231" href="#L231">231</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L232" href="#L232">232</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L233" href="#L233">233</a> }
-<a class="jxr_linenumber" name="L234" href="#L234">234</a> }
-<a class="jxr_linenumber" name="L235" href="#L235">235</a> }
-<a class="jxr_linenumber" name="L236" href="#L236">236</a>
-<a class="jxr_linenumber" name="L237" href="#L237">237</a> @Test
-<a class="jxr_linenumber" name="L238" href="#L238">238</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEmptyFile() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L239" href="#L239">239</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(<span class="jxr_string">""</span>, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L240" href="#L240">240</a> assertNull(parser.nextRecord());
-<a class="jxr_linenumber" name="L241" href="#L241">241</a> }
-<a class="jxr_linenumber" name="L242" href="#L242">242</a>
-<a class="jxr_linenumber" name="L243" href="#L243">243</a> @Test
-<a class="jxr_linenumber" name="L244" href="#L244">244</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testCSV57() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L245" href="#L245">245</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(<span class="jxr_string">""</span>, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L246" href="#L246">246</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> list = parser.getRecords();
-<a class="jxr_linenumber" name="L247" href="#L247">247</a> assertNotNull(list);
-<a class="jxr_linenumber" name="L248" href="#L248">248</a> assertEquals(0, list.size());
-<a class="jxr_linenumber" name="L249" href="#L249">249</a> }
-<a class="jxr_linenumber" name="L250" href="#L250">250</a>
-<a class="jxr_linenumber" name="L251" href="#L251">251</a> @Test
-<a class="jxr_linenumber" name="L252" href="#L252">252</a> @Ignore
-<a class="jxr_linenumber" name="L253" href="#L253">253</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscapingOld() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L254" href="#L254">254</a> <strong class="jxr_keyword">final</strong> String code =
-<a class="jxr_linenumber" name="L255" href="#L255">255</a> <span class="jxr_string">"one,two,three\n"</span>
-<a class="jxr_linenumber" name="L256" href="#L256">256</a> + <span class="jxr_string">"on\\\"e,two\n"</span>
-<a class="jxr_linenumber" name="L257" href="#L257">257</a> + <span class="jxr_string">"on\"e,two\n"</span>
-<a class="jxr_linenumber" name="L258" href="#L258">258</a> + <span class="jxr_string">"one,\"tw\\\"o\"\n"</span>
-<a class="jxr_linenumber" name="L259" href="#L259">259</a> + <span class="jxr_string">"one,\"t\\,wo\"\n"</span>
-<a class="jxr_linenumber" name="L260" href="#L260">260</a> + <span class="jxr_string">"one,two,\"th,ree\"\n"</span>
-<a class="jxr_linenumber" name="L261" href="#L261">261</a> + <span class="jxr_string">"\"a\\\\\"\n"</span>
-<a class="jxr_linenumber" name="L262" href="#L262">262</a> + <span class="jxr_string">"a\\,b\n"</span>
-<a class="jxr_linenumber" name="L263" href="#L263">263</a> + <span class="jxr_string">"\"a\\\\,b\""</span>;
-<a class="jxr_linenumber" name="L264" href="#L264">264</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L265" href="#L265">265</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"three"</span>},
-<a class="jxr_linenumber" name="L266" href="#L266">266</a> {<span class="jxr_string">"on\\\"e"</span>, <span class="jxr_string">"two"</span>},
-<a class="jxr_linenumber" name="L267" href="#L267">267</a> {<span class="jxr_string">"on\"e"</span>, <span class="jxr_string">"two"</span>},
-<a class="jxr_linenumber" name="L268" href="#L268">268</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"tw\"o"</span>},
-<a class="jxr_linenumber" name="L269" href="#L269">269</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"t\\,wo"</span>}, <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
-<a class="jxr_linenumber" name="L270" href="#L270">270</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"th,ree"</span>},
-<a class="jxr_linenumber" name="L271" href="#L271">271</a> {<span class="jxr_string">"a\\\\"</span>}, <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
-<a class="jxr_linenumber" name="L272" href="#L272">272</a> {<span class="jxr_string">"a\\"</span>, <span class="jxr_string">"b"</span>}, <em class="jxr_comment">// a backslash must be returnd</em>
-<a class="jxr_linenumber" name="L273" href="#L273">273</a> {<span class="jxr_string">"a\\\\,b"</span>} <em class="jxr_comment">// backslash in quotes only escapes a delimiter (",")</em>
-<a class="jxr_linenumber" name="L274" href="#L274">274</a> };
-<a class="jxr_linenumber" name="L275" href="#L275">275</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L276" href="#L276">276</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L277" href="#L277">277</a> assertEquals(res.length, records.size());
-<a class="jxr_linenumber" name="L278" href="#L278">278</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L279" href="#L279">279</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
-<a class="jxr_linenumber" name="L280" href="#L280">280</a> assertArrayEquals(res[i], records.get(i).values());
-<a class="jxr_linenumber" name="L281" href="#L281">281</a> }
-<a class="jxr_linenumber" name="L282" href="#L282">282</a> }
+<a class="jxr_linenumber" name="L192" href="#L192">192</a> @Ignore(<span class="jxr_string">"CSV-107"</span>)
+<a class="jxr_linenumber" name="L193" href="#L193">193</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBOM() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L194" href="#L194">194</a> URL url = ClassLoader.getSystemClassLoader().getResource(<span class="jxr_string">"CSVFileParser/bom.csv"</span>);
+<a class="jxr_linenumber" name="L195" href="#L195">195</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(url, <strong class="jxr_keyword">null</strong>, CSVFormat.EXCEL.withHeader());
+<a class="jxr_linenumber" name="L196" href="#L196">196</a> <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="L197" href="#L197">197</a> <strong class="jxr_keyword">for</strong> (CSVRecord record : parser) {
+<a class="jxr_linenumber" name="L198" href="#L198">198</a> <strong class="jxr_keyword">final</strong> String string = record.get(<span class="jxr_string">"Date"</span>);
+<a class="jxr_linenumber" name="L199" href="#L199">199</a> Assert.assertNotNull(string);
+<a class="jxr_linenumber" name="L200" href="#L200">200</a> <em class="jxr_comment">//System.out.println("date: " + record.get("Date"));</em>
+<a class="jxr_linenumber" name="L201" href="#L201">201</a> }
+<a class="jxr_linenumber" name="L202" href="#L202">202</a> } <strong class="jxr_keyword">finally</strong> {
+<a class="jxr_linenumber" name="L203" href="#L203">203</a> parser.close();
+<a class="jxr_linenumber" name="L204" href="#L204">204</a> }
+<a class="jxr_linenumber" name="L205" href="#L205">205</a> }
+<a class="jxr_linenumber" name="L206" href="#L206">206</a>
+<a class="jxr_linenumber" name="L207" href="#L207">207</a> @Test
+<a class="jxr_linenumber" name="L208" href="#L208">208</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBOMInputStream() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L209" href="#L209">209</a> URL url = ClassLoader.getSystemClassLoader().getResource(<span class="jxr_string">"CSVFileParser/bom.csv"</span>);
+<a class="jxr_linenumber" name="L210" href="#L210">210</a> Reader reader = <strong class="jxr_keyword">new</strong> InputStreamReader(<strong class="jxr_keyword">new</strong> BOMInputStream(url.openStream()), <span class="jxr_string">"UTF-8"</span>);
+<a class="jxr_linenumber" name="L211" href="#L211">211</a> <strong class="jxr_keyword">final</strong> CSVParser parser = <strong class="jxr_keyword">new</strong> CSVParser(reader, CSVFormat.EXCEL.withHeader());
+<a class="jxr_linenumber" name="L212" href="#L212">212</a> <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="L213" href="#L213">213</a> <strong class="jxr_keyword">for</strong> (CSVRecord record : parser) {
+<a class="jxr_linenumber" name="L214" href="#L214">214</a> <strong class="jxr_keyword">final</strong> String string = record.get(<span class="jxr_string">"Date"</span>);
+<a class="jxr_linenumber" name="L215" href="#L215">215</a> Assert.assertNotNull(string);
+<a class="jxr_linenumber" name="L216" href="#L216">216</a> <em class="jxr_comment">//System.out.println("date: " + record.get("Date"));</em>
+<a class="jxr_linenumber" name="L217" href="#L217">217</a> }
+<a class="jxr_linenumber" name="L218" href="#L218">218</a> } <strong class="jxr_keyword">finally</strong> {
+<a class="jxr_linenumber" name="L219" href="#L219">219</a> parser.close();
+<a class="jxr_linenumber" name="L220" href="#L220">220</a> reader.close();
+<a class="jxr_linenumber" name="L221" href="#L221">221</a> }
+<a class="jxr_linenumber" name="L222" href="#L222">222</a> }
+<a class="jxr_linenumber" name="L223" href="#L223">223</a>
+<a class="jxr_linenumber" name="L224" href="#L224">224</a> @Test
+<a class="jxr_linenumber" name="L225" href="#L225">225</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testCarriageReturnEndings() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L226" href="#L226">226</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">"foo\rbaar,\rhello,world\r,kanu"</span>;
+<a class="jxr_linenumber" name="L227" href="#L227">227</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L228" href="#L228">228</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L229" href="#L229">229</a> assertEquals(4, records.size());
+<a class="jxr_linenumber" name="L230" href="#L230">230</a> parser.close();
+<a class="jxr_linenumber" name="L231" href="#L231">231</a> }
+<a class="jxr_linenumber" name="L232" href="#L232">232</a>
+<a class="jxr_linenumber" name="L233" href="#L233">233</a> @Test
+<a class="jxr_linenumber" name="L234" href="#L234">234</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testCarriageReturnLineFeedEndings() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L235" href="#L235">235</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">"foo\r\nbaar,\r\nhello,world\r\n,kanu"</span>;
+<a class="jxr_linenumber" name="L236" href="#L236">236</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L237" href="#L237">237</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L238" href="#L238">238</a> assertEquals(4, records.size());
+<a class="jxr_linenumber" name="L239" href="#L239">239</a> parser.close();
+<a class="jxr_linenumber" name="L240" href="#L240">240</a> }
+<a class="jxr_linenumber" name="L241" href="#L241">241</a>
+<a class="jxr_linenumber" name="L242" href="#L242">242</a> @Test(expected = NoSuchElementException.<strong class="jxr_keyword">class</strong>)
+<a class="jxr_linenumber" name="L243" href="#L243">243</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testClose() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="L244" href="#L244">244</a> <strong class="jxr_keyword">final</strong> Reader in = <strong class="jxr_keyword">new</strong> StringReader(<span class="jxr_string">"# comment\na,b,c\n1,2,3\nx,y,z"</span>);
+<a class="jxr_linenumber" name="L245" href="#L245">245</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVFormat.DEFAULT.withCommentStart('#').withHeader().parse(in);
+<a class="jxr_linenumber" name="L246" href="#L246">246</a> <strong class="jxr_keyword">final</strong> Iterator<CSVRecord> records = parser.iterator();
+<a class="jxr_linenumber" name="L247" href="#L247">247</a> assertTrue(records.hasNext());
+<a class="jxr_linenumber" name="L248" href="#L248">248</a> parser.close();
+<a class="jxr_linenumber" name="L249" href="#L249">249</a> assertFalse(records.hasNext());
+<a class="jxr_linenumber" name="L250" href="#L250">250</a> records.next();
+<a class="jxr_linenumber" name="L251" href="#L251">251</a> }
+<a class="jxr_linenumber" name="L252" href="#L252">252</a>
+<a class="jxr_linenumber" name="L253" href="#L253">253</a> @Test
+<a class="jxr_linenumber" name="L254" href="#L254">254</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testCSV57() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="L255" href="#L255">255</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(<span class="jxr_string">""</span>, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L256" href="#L256">256</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> list = parser.getRecords();
+<a class="jxr_linenumber" name="L257" href="#L257">257</a> assertNotNull(list);
+<a class="jxr_linenumber" name="L258" href="#L258">258</a> assertEquals(0, list.size());
+<a class="jxr_linenumber" name="L259" href="#L259">259</a> parser.close();
+<a class="jxr_linenumber" name="L260" href="#L260">260</a> }
+<a class="jxr_linenumber" name="L261" href="#L261">261</a>
+<a class="jxr_linenumber" name="L262" href="#L262">262</a> @Test
+<a class="jxr_linenumber" name="L263" href="#L263">263</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDefaultFormat() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L264" href="#L264">264</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">""</span>
+<a class="jxr_linenumber" name="L265" href="#L265">265</a> + <span class="jxr_string">"a,b#\n"</span> <em class="jxr_comment">// 1)</em>
+<a class="jxr_linenumber" name="L266" href="#L266">266</a> + <span class="jxr_string">"\"\n\",\" \",#\n"</span> <em class="jxr_comment">// 2)</em>
+<a class="jxr_linenumber" name="L267" href="#L267">267</a> + <span class="jxr_string">"#,\"\"\n"</span> <em class="jxr_comment">// 3)</em>
+<a class="jxr_linenumber" name="L268" href="#L268">268</a> + <span class="jxr_string">"# Final comment\n"</span><em class="jxr_comment">// 4)</em>
+<a class="jxr_linenumber" name="L269" href="#L269">269</a> ;
+<a class="jxr_linenumber" name="L270" href="#L270">270</a> <strong class="jxr_keyword">final</strong> String[][] res = {
+<a class="jxr_linenumber" name="L271" href="#L271">271</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b#"</span>},
+<a class="jxr_linenumber" name="L272" href="#L272">272</a> {<span class="jxr_string">"\n"</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">"#"</span>},
+<a class="jxr_linenumber" name="L273" href="#L273">273</a> {<span class="jxr_string">"#"</span>, <span class="jxr_string">""</span>},
+<a class="jxr_linenumber" name="L274" href="#L274">274</a> {<span class="jxr_string">"# Final comment"</span>}
+<a class="jxr_linenumber" name="L275" href="#L275">275</a> };
+<a class="jxr_linenumber" name="L276" href="#L276">276</a>
+<a class="jxr_linenumber" name="L277" href="#L277">277</a> CSVFormat format = CSVFormat.DEFAULT;
+<a class="jxr_linenumber" name="L278" href="#L278">278</a> assertFalse(format.isCommentingEnabled());
+<a class="jxr_linenumber" name="L279" href="#L279">279</a>
+<a class="jxr_linenumber" name="L280" href="#L280">280</a> CSVParser parser = CSVParser.parse(code, format);
+<a class="jxr_linenumber" name="L281" href="#L281">281</a> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L282" href="#L282">282</a> assertTrue(records.size() > 0);
<a class="jxr_linenumber" name="L283" href="#L283">283</a>
-<a class="jxr_linenumber" name="L284" href="#L284">284</a> @Test
-<a class="jxr_linenumber" name="L285" href="#L285">285</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscaping() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L286" href="#L286">286</a>
-<a class="jxr_linenumber" name="L287" href="#L287">287</a> <em class="jxr_comment">// To avoid confusion over the need for escaping chars in java code,</em>
-<a class="jxr_linenumber" name="L288" href="#L288">288</a> <em class="jxr_comment">// We will test with a forward slash as the escape char, and a single</em>
-<a class="jxr_linenumber" name="L289" href="#L289">289</a> <em class="jxr_comment">// quote as the encapsulator.</em>
+<a class="jxr_linenumber" name="L284" href="#L284">284</a> Utils.compare(<span class="jxr_string">"Failed to parse without comments"</span>, res, records);
+<a class="jxr_linenumber" name="L285" href="#L285">285</a>
+<a class="jxr_linenumber" name="L286" href="#L286">286</a> <strong class="jxr_keyword">final</strong> String[][] res_comments = {
+<a class="jxr_linenumber" name="L287" href="#L287">287</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b#"</span>},
+<a class="jxr_linenumber" name="L288" href="#L288">288</a> {<span class="jxr_string">"\n"</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">"#"</span>},
+<a class="jxr_linenumber" name="L289" href="#L289">289</a> };
<a class="jxr_linenumber" name="L290" href="#L290">290</a>
-<a class="jxr_linenumber" name="L291" href="#L291">291</a> <strong class="jxr_keyword">final</strong> String code =
-<a class="jxr_linenumber" name="L292" href="#L292">292</a> <span class="jxr_string">"one,two,three\n"</span> <em class="jxr_comment">// 0</em>
-<a class="jxr_linenumber" name="L293" href="#L293">293</a> + <span class="jxr_string">"'',''\n"</span> <em class="jxr_comment">// 1) empty encapsulators</em>
-<a class="jxr_linenumber" name="L294" href="#L294">294</a> + <span class="jxr_string">"/',/'\n"</span> <em class="jxr_comment">// 2) single encapsulators</em>
-<a class="jxr_linenumber" name="L295" href="#L295">295</a> + <span class="jxr_string">"'/'','/''\n"</span> <em class="jxr_comment">// 3) single encapsulators encapsulated via escape</em>
-<a class="jxr_linenumber" name="L296" href="#L296">296</a> + <span class="jxr_string">"'''',''''\n"</span> <em class="jxr_comment">// 4) single encapsulators encapsulated via doubling</em>
-<a class="jxr_linenumber" name="L297" href="#L297">297</a> + <span class="jxr_string">"/,,/,\n"</span> <em class="jxr_comment">// 5) separator escaped</em>
-<a class="jxr_linenumber" name="L298" href="#L298">298</a> + <span class="jxr_string">"//,//\n"</span> // 6) escape escaped
-<a class="jxr_linenumber" name="L299" href="#L299">299</a> + <span class="jxr_string">"'//','//'\n"</span> // 7) escape escaped in encapsulation
-<a class="jxr_linenumber" name="L300" href="#L300">300</a> + <span class="jxr_string">" 8 , \"quoted \"\" /\" // string\" \n"</span> // don't eat spaces
-<a class="jxr_linenumber" name="L301" href="#L301">301</a> + <span class="jxr_string">"9, /\n \n"</span> <em class="jxr_comment">// escaped newline</em>
-<a class="jxr_linenumber" name="L302" href="#L302">302</a> + <span class="jxr_string">""</span>;
-<a class="jxr_linenumber" name="L303" href="#L303">303</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L304" href="#L304">304</a> {<span class="jxr_string">"one"</span>, <span class="jxr_string">"two"</span>, <span class="jxr_string">"three"</span>}, <em class="jxr_comment">// 0</em>
-<a class="jxr_linenumber" name="L305" href="#L305">305</a> {<span class="jxr_string">""</span>, <span class="jxr_string">""</span>}, <em class="jxr_comment">// 1</em>
-<a class="jxr_linenumber" name="L306" href="#L306">306</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 2</em>
-<a class="jxr_linenumber" name="L307" href="#L307">307</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 3</em>
-<a class="jxr_linenumber" name="L308" href="#L308">308</a> {<span class="jxr_string">"'"</span>, <span class="jxr_string">"'"</span>}, <em class="jxr_comment">// 4</em>
-<a class="jxr_linenumber" name="L309" href="#L309">309</a> {<span class="jxr_string">","</span>, <span class="jxr_string">","</span>}, <em class="jxr_comment">// 5</em>
-<a class="jxr_linenumber" name="L310" href="#L310">310</a> {<span class="jxr_string">"/"</span>, <span class="jxr_string">"/"</span>}, <em class="jxr_comment">// 6</em>
-<a class="jxr_linenumber" name="L311" href="#L311">311</a> {<span class="jxr_string">"/"</span>, <span class="jxr_string">"/"</span>}, <em class="jxr_comment">// 7</em>
-<a class="jxr_linenumber" name="L312" href="#L312">312</a> {<span class="jxr_string">" 8 "</span>, <span class="jxr_string">" \"quoted \"\" /\" / string\" "</span>},
-<a class="jxr_linenumber" name="L313" href="#L313">313</a> {<span class="jxr_string">"9"</span>, <span class="jxr_string">" \n "</span>},
+<a class="jxr_linenumber" name="L291" href="#L291">291</a> format = CSVFormat.DEFAULT.withCommentStart('#');
+<a class="jxr_linenumber" name="L292" href="#L292">292</a> parser.close();
+<a class="jxr_linenumber" name="L293" href="#L293">293</a> parser = CSVParser.parse(code, format);
+<a class="jxr_linenumber" name="L294" href="#L294">294</a> records = parser.getRecords();
+<a class="jxr_linenumber" name="L295" href="#L295">295</a>
+<a class="jxr_linenumber" name="L296" href="#L296">296</a> Utils.compare(<span class="jxr_string">"Failed to parse with comments"</span>, res_comments, records);
+<a class="jxr_linenumber" name="L297" href="#L297">297</a> parser.close();
+<a class="jxr_linenumber" name="L298" href="#L298">298</a> }
+<a class="jxr_linenumber" name="L299" href="#L299">299</a>
+<a class="jxr_linenumber" name="L300" href="#L300">300</a> @Test
+<a class="jxr_linenumber" name="L301" href="#L301">301</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEmptyFile() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="L302" href="#L302">302</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(<span class="jxr_string">""</span>, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L303" href="#L303">303</a> assertNull(parser.nextRecord());
+<a class="jxr_linenumber" name="L304" href="#L304">304</a> parser.close();
+<a class="jxr_linenumber" name="L305" href="#L305">305</a> }
+<a class="jxr_linenumber" name="L306" href="#L306">306</a>
+<a class="jxr_linenumber" name="L307" href="#L307">307</a> @Test
+<a class="jxr_linenumber" name="L308" href="#L308">308</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testEmptyLineBehaviourCSV() <strong class="jxr_keyword">throws</strong> Exception {
+<a class="jxr_linenumber" name="L309" href="#L309">309</a> <strong class="jxr_keyword">final</strong> String[] codes = {
+<a class="jxr_linenumber" name="L310" href="#L310">310</a> <span class="jxr_string">"hello,\r\n\r\n\r\n"</span>,
+<a class="jxr_linenumber" name="L311" href="#L311">311</a> <span class="jxr_string">"hello,\n\n\n"</span>,
+<a class="jxr_linenumber" name="L312" href="#L312">312</a> <span class="jxr_string">"hello,\"\"\r\n\r\n\r\n"</span>,
+<a class="jxr_linenumber" name="L313" href="#L313">313</a> <span class="jxr_string">"hello,\"\"\n\n\n"</span>
<a class="jxr_linenumber" name="L314" href="#L314">314</a> };
-<a class="jxr_linenumber" name="L315" href="#L315">315</a>
-<a class="jxr_linenumber" name="L316" href="#L316">316</a>
-<a class="jxr_linenumber" name="L317" href="#L317">317</a> <strong class="jxr_keyword">final</strong> CSVFormat format = CSVFormat.newFormat(',').withQuoteChar('\'')
-<a class="jxr_linenumber" name="L318" href="#L318">318</a> .withRecordSeparator(CRLF).withEscape('/').withIgnoreEmptyLines(<strong class="jxr_keyword">true</strong>);
-<a class="jxr_linenumber" name="L319" href="#L319">319</a>
-<a class="jxr_linenumber" name="L320" href="#L320">320</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, format);
-<a class="jxr_linenumber" name="L321" href="#L321">321</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L322" href="#L322">322</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L323" href="#L323">323</a>
-<a class="jxr_linenumber" name="L324" href="#L324">324</a> Utils.compare(<span class="jxr_string">"Records do not match expected result"</span>, res, records);
-<a class="jxr_linenumber" name="L325" href="#L325">325</a> }
-<a class="jxr_linenumber" name="L326" href="#L326">326</a>
-<a class="jxr_linenumber" name="L327" href="#L327">327</a> @Test
-<a class="jxr_linenumber" name="L328" href="#L328">328</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBackslashEscaping2() <strong class="jxr_keyword">throws</strong> IOException {
+<a class="jxr_linenumber" name="L315" href="#L315">315</a> <strong class="jxr_keyword">final</strong> String[][] res = {
+<a class="jxr_linenumber" name="L316" href="#L316">316</a> {<span class="jxr_string">"hello"</span>, <span class="jxr_string">""</span>} <em class="jxr_comment">// CSV format ignores empty lines</em>
+<a class="jxr_linenumber" name="L317" href="#L317">317</a> };
+<a class="jxr_linenumber" name="L318" href="#L318">318</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">final</strong> String code : codes) {
+<a class="jxr_linenumber" name="L319" href="#L319">319</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
+<a class="jxr_linenumber" name="L320" href="#L320">320</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
+<a class="jxr_linenumber" name="L321" href="#L321">321</a> assertEquals(res.length, records.size());
+<a class="jxr_linenumber" name="L322" href="#L322">322</a> assertTrue(records.size() > 0);
+<a class="jxr_linenumber" name="L323" href="#L323">323</a> <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i < res.length; i++) {
+<a class="jxr_linenumber" name="L324" href="#L324">324</a> assertArrayEquals(res[i], records.get(i).values());
+<a class="jxr_linenumber" name="L325" href="#L325">325</a> }
+<a class="jxr_linenumber" name="L326" href="#L326">326</a> parser.close();
+<a class="jxr_linenumber" name="L327" href="#L327">327</a> }
+<a class="jxr_linenumber" name="L328" href="#L328">328</a> }
<a class="jxr_linenumber" name="L329" href="#L329">329</a>
-<a class="jxr_linenumber" name="L330" href="#L330">330</a> <em class="jxr_comment">// To avoid confusion over the need for escaping chars in java code,</em>
-<a class="jxr_linenumber" name="L331" href="#L331">331</a> <em class="jxr_comment">// We will test with a forward slash as the escape char, and a single</em>
-<a class="jxr_linenumber" name="L332" href="#L332">332</a> <em class="jxr_comment">// quote as the encapsulator.</em>
-<a class="jxr_linenumber" name="L333" href="#L333">333</a>
-<a class="jxr_linenumber" name="L334" href="#L334">334</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">""</span>
-<a class="jxr_linenumber" name="L335" href="#L335">335</a> + <span class="jxr_string">" , , \n"</span> <em class="jxr_comment">// 1)</em>
-<a class="jxr_linenumber" name="L336" href="#L336">336</a> + <span class="jxr_string">" \t , , \n"</span> <em class="jxr_comment">// 2)</em>
-<a class="jxr_linenumber" name="L337" href="#L337">337</a> + <span class="jxr_string">" // , /, , /,\n"</span> // 3)
-<a class="jxr_linenumber" name="L338" href="#L338">338</a> + <span class="jxr_string">""</span>;
-<a class="jxr_linenumber" name="L339" href="#L339">339</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L340" href="#L340">340</a> {<span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>}, <em class="jxr_comment">// 1</em>
-<a class="jxr_linenumber" name="L341" href="#L341">341</a> {<span class="jxr_string">" \t "</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">" "</span>}, <em class="jxr_comment">// 2</em>
-<a class="jxr_linenumber" name="L342" href="#L342">342</a> {<span class="jxr_string">" / "</span>, <span class="jxr_string">" , "</span>, <span class="jxr_string">" ,"</span>}, <em class="jxr_comment">// 3</em>
-<a class="jxr_linenumber" name="L343" href="#L343">343</a> };
-<a class="jxr_linenumber" name="L344" href="#L344">344</a>
-<a class="jxr_linenumber" name="L345" href="#L345">345</a>
-<a class="jxr_linenumber" name="L346" href="#L346">346</a> <strong class="jxr_keyword">final</strong> CSVFormat format = CSVFormat.newFormat(',')
-<a class="jxr_linenumber" name="L347" href="#L347">347</a> .withRecordSeparator(CRLF).withEscape('/').withIgnoreEmptyLines(<strong class="jxr_keyword">true</strong>);
-<a class="jxr_linenumber" name="L348" href="#L348">348</a>
-<a class="jxr_linenumber" name="L349" href="#L349">349</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, format);
-<a class="jxr_linenumber" name="L350" href="#L350">350</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L351" href="#L351">351</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L352" href="#L352">352</a>
-<a class="jxr_linenumber" name="L353" href="#L353">353</a> Utils.compare(<span class="jxr_string">""</span>, res, records);
-<a class="jxr_linenumber" name="L354" href="#L354">354</a> }
-<a class="jxr_linenumber" name="L355" href="#L355">355</a>
-<a class="jxr_linenumber" name="L356" href="#L356">356</a> @Test
-<a class="jxr_linenumber" name="L357" href="#L357">357</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDefaultFormat() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L358" href="#L358">358</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">""</span>
-<a class="jxr_linenumber" name="L359" href="#L359">359</a> + <span class="jxr_string">"a,b#\n"</span> <em class="jxr_comment">// 1)</em>
-<a class="jxr_linenumber" name="L360" href="#L360">360</a> + <span class="jxr_string">"\"\n\",\" \",#\n"</span> <em class="jxr_comment">// 2)</em>
-<a class="jxr_linenumber" name="L361" href="#L361">361</a> + <span class="jxr_string">"#,\"\"\n"</span> <em class="jxr_comment">// 3)</em>
-<a class="jxr_linenumber" name="L362" href="#L362">362</a> + <span class="jxr_string">"# Final comment\n"</span><em class="jxr_comment">// 4)</em>
-<a class="jxr_linenumber" name="L363" href="#L363">363</a> ;
-<a class="jxr_linenumber" name="L364" href="#L364">364</a> <strong class="jxr_keyword">final</strong> String[][] res = {
-<a class="jxr_linenumber" name="L365" href="#L365">365</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b#"</span>},
-<a class="jxr_linenumber" name="L366" href="#L366">366</a> {<span class="jxr_string">"\n"</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">"#"</span>},
-<a class="jxr_linenumber" name="L367" href="#L367">367</a> {<span class="jxr_string">"#"</span>, <span class="jxr_string">""</span>},
-<a class="jxr_linenumber" name="L368" href="#L368">368</a> {<span class="jxr_string">"# Final comment"</span>}
-<a class="jxr_linenumber" name="L369" href="#L369">369</a> };
-<a class="jxr_linenumber" name="L370" href="#L370">370</a>
-<a class="jxr_linenumber" name="L371" href="#L371">371</a> CSVFormat format = CSVFormat.DEFAULT;
-<a class="jxr_linenumber" name="L372" href="#L372">372</a> assertFalse(format.isCommentingEnabled());
-<a class="jxr_linenumber" name="L373" href="#L373">373</a>
-<a class="jxr_linenumber" name="L374" href="#L374">374</a> CSVParser parser = CSVParser.parse(code, format);
-<a class="jxr_linenumber" name="L375" href="#L375">375</a> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L376" href="#L376">376</a> assertTrue(records.size() > 0);
-<a class="jxr_linenumber" name="L377" href="#L377">377</a>
-<a class="jxr_linenumber" name="L378" href="#L378">378</a> Utils.compare(<span class="jxr_string">"Failed to parse without comments"</span>, res, records);
-<a class="jxr_linenumber" name="L379" href="#L379">379</a>
-<a class="jxr_linenumber" name="L380" href="#L380">380</a> <strong class="jxr_keyword">final</strong> String[][] res_comments = {
-<a class="jxr_linenumber" name="L381" href="#L381">381</a> {<span class="jxr_string">"a"</span>, <span class="jxr_string">"b#"</span>},
-<a class="jxr_linenumber" name="L382" href="#L382">382</a> {<span class="jxr_string">"\n"</span>, <span class="jxr_string">" "</span>, <span class="jxr_string">"#"</span>},
-<a class="jxr_linenumber" name="L383" href="#L383">383</a> };
-<a class="jxr_linenumber" name="L384" href="#L384">384</a>
-<a class="jxr_linenumber" name="L385" href="#L385">385</a> format = CSVFormat.DEFAULT.withCommentStart('#');
-<a class="jxr_linenumber" name="L386" href="#L386">386</a> parser = CSVParser.parse(code, format);
-<a class="jxr_linenumber" name="L387" href="#L387">387</a> records = parser.getRecords();
-<a class="jxr_linenumber" name="L388" href="#L388">388</a>
-<a class="jxr_linenumber" name="L389" href="#L389">389</a> Utils.compare(<span class="jxr_string">"Failed to parse with comments"</span>, res_comments, records);
-<a class="jxr_linenumber" name="L390" href="#L390">390</a> }
-<a class="jxr_linenumber" name="L391" href="#L391">391</a>
-<a class="jxr_linenumber" name="L392" href="#L392">392</a> @Test
-<a class="jxr_linenumber" name="L393" href="#L393">393</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testCarriageReturnLineFeedEndings() <strong class="jxr_keyword">throws</strong> IOException {
-<a class="jxr_linenumber" name="L394" href="#L394">394</a> <strong class="jxr_keyword">final</strong> String code = <span class="jxr_string">"foo\r\nbaar,\r\nhello,world\r\n,kanu"</span>;
-<a class="jxr_linenumber" name="L395" href="#L395">395</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVParser.parse(code, CSVFormat.DEFAULT);
-<a class="jxr_linenumber" name="L396" href="#L396">396</a> <strong class="jxr_keyword">final</strong> List<CSVRecord> records = parser.getRecords();
-<a class="jxr_linenumber" name="L397" href="#L397">397</a> assertEquals(4, records.size());
-<a class="jxr_linenumber" name="L398" href="#L398">398</a> }
-<a class="jxr_linenumber" name="L399" href="#L399">399</a>
-<a class="jxr_linenumber" name="L400" href="#L400">400</a> @Test(expected = NoSuchElementException.<strong class="jxr_keyword">class</strong>)
-<a class="jxr_linenumber" name="L401" href="#L401">401</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testClose() <strong class="jxr_keyword">throws</strong> Exception {
-<a class="jxr_linenumber" name="L402" href="#L402">402</a> <strong class="jxr_keyword">final</strong> Reader in = <strong class="jxr_keyword">new</strong> StringReader(<span class="jxr_string">"# comment\na,b,c\n1,2,3\nx,y,z"</span>);
-<a class="jxr_linenumber" name="L403" href="#L403">403</a> <strong class="jxr_keyword">final</strong> CSVParser parser = CSVFormat.DEFAULT.withCommentStart('#').withHeader().parse(in);
-<a class="jxr_linenumber" name="L404" href="#L404">404</a> <strong class="jxr_keyword">final</strong> Iterator<CSVRecord> records = parser.iterator();
-<a class="jxr_linenumber" name="L405" href="#L405">405</a> assertTrue(records.hasNext());
-<a class="jxr_linenumber" name="L406" href="#L406">406</a> parser.close();
[... 990 lines stripped ...]