CSV Interface v3.1.5

Improvements:

• The delimiter guesser is more smarter, being now able to disambiguate cases where there are fields with embedded tables and/or CSV files with persistent records that could not be disambiguated with the table scoring method. In this new version, subtables are also scored. For example, the delimiter guesser can detect that the semicolon (;) is the field delimiter in the following CSV file (check Rainbow CSV issue #92):

1;Orange VUHF;K6CF AnhmHlls|K6COV Orng|K6MWT LkFrstSntg|K6NBR NwprtBch|K6QEH FllrtnRyth|K6SOA LgnBch|K6SOA SnClmnt|K6SOA TrbcCnyn|K6SYU FllrtnSt.J|KA6EEK IrvnSgnlP|KE6FUZ AnhmDsnyl|N6ME Fllrtn|N6SLD LkFrstSntg|W6HBR OrngPlsnts|W6KRW SnClmnt|W6KRW TstnLmRdg|W6VLD HntngtnBch|WA6FV FntnVlly|WA6YNT Plcnt|WB6HRO CstMsCtyH;145.1400|145.1600|145.2200|145.2400|145.2600|145.4000|145.4200|146.0250|146.2650|146.7900|146.8950|146.8950|146.9400|146.9700|147.0600|147.4350|147.4650|147.6450|147.8550|147.9150;144.5400|144.5600|144.6200|144.6400|144.6600|144.8000|144.8200|146.6250|146.8650|146.1900|146.2950|146.2950|146.3400|146.3700|147.6600|146.4000|146.5050|147.0450|147.2550|147.3150;OFF;OFF;OFF;;;OFF;;;Selected;0.5;0.5;0.1;0.1

• More delimiter guessing tests have been added.

CSV Interface v3.1.4

Improvements:

• Improved delimiter guesser.
• More delimiter guessing tests have been added. Samples provided with reported CleverCSV issues (#15, #35, #37).
• Renamed some auxiliary guessing methods.

CSV Interface v3.1.3

Improvements:

• Delimiters guessing improved. Tested with samples provided with reported Papa Parse issues (#804, #681, #658, #688) and others provided by @sancarn!
• Added delimiter guessing unit test.
• Added the ability to use any character (excluding space character) as a field delimiter. By default they are comma, semicolon, tab, pipe and colon.
• Updated all test results.

CSV Interface v3.1.2

Bugs fixed:

• Unit test missing configuration.
• Unexpected ending of the import operation.

Improvements:

• Unix quote escape mechanism is now supported via unixEscapeMechanism property of parseConfig object.
• A CSV parsing test with Unix escape has been added.
• User can specify tilde as quote character.
• Added EnforcedQuotation option to ExportToCSV method.
• Removed nulstring member from EscapeTokens enumeration.
• Multiline fields are treated as string despite dynamic typing configuration.
• Updated documentation.

CSV Interface v3.1.1

Bugs fixed:

• Fields that were not well escaped could not be handled as expected when exporting.

Improvements:

• Adds one more test, selected from Papa Parse issue 121.
• Updated docs.

CSV Interface v3.1.0

Bugs fixed:

• Escaped fields could not be handled well. It is now expected that quoted fields will be as close as possible to the RFC-4180 specifications when writing this kind of fields on a CSV file.
• Unable to guess delimiters.
• Error alerts were not reset after attempting to guess the delimiters.
• Unable to handle quoted fields with embedded line breaks.
• Unable to stop the analysis when the user requests a number of records but the end of the file is reached.
• Unable to detect the variation of the number of fields when the first record has more fields than the following ones.
• Unable to adjust the buffer size when the specified record delimiter is missing.

Improvements:

• A Test Driven Development (TDD) suite has been added.
• Option added: user can instruct the parser to turn all the stream's record delimiters to LF.
• Records are ignored only when they are empty or commented out, as specified in the skipCommentLines and skipEmptyLines options. This Closes #9.
• Now the ImportFromCSVString method can guess the delimiters specified in the parseConfig.delimitersGuessing property.
• More import and advanced examples have been added.
• Added FAQ section.
• Added error messages docs.
• Added options: SkipCommentLines, SkipEmptyLines.
• Updated ECPTextStream module.
• Some lines in the import procedures have been refactored or rewritten.
• Deprecated option: catchMeaninglessRecords.
• The parser allows the following characters as comment tokens: [#](default) , [!], [$], [%], and [&].
• Updated benchmarks.
• Updated docs.

CSV Interface v3.0.8

• Update: ECPTextStream class module.

CSV Interface v3.0.7

• Bug Fixed: Out of bound when subsetting.

CSV Interface v3.0.6

• Enhancement: added support to export ECPArrayList objects.
• Enhancement: added GetCSVsubset method.
• Enhancement: added CSVdatasetSplit method.
• Bug Fixed: error appending to existing files.
• Bug Fixed: the comment token in the CopyConfig method of the parserConfig module is not recognized.
• Update: delimiters guessing is now optional when exporting to CSV files.
• Update: DOC repo.

CSV Interface v3.0.5

• Enhancement: colons are accepted as field delimiters.