CSV Interface v4.2.0

This new version includes many useful features that had not been covered and suggested by some enthusiasts (see this and this other subreddit post). Now VBA CSV Interface is shaping up to be a much more powerful tool when working with CSV files.

Improvements

• Like SQL joins: left, Right and Inner joins for tables, flavored for VBA users. CSV Interface becomes the only VBA library that supports this feature.
• Group method: this will allow users to accumulate with COUNT, MIN, MAX, SUM and AVG operations.
• Reduce method: to reduce records by executing functions over fields through records.
• Sorting large files: useful to allow sorting a CSV file on disk without overloading memory, currently this feature is very required but supported by few libraries.

Members changes

CSVinterface

• CSVsubsetSplit now accepts a list of fields to split on and output to a path ending in "-WorkDir".
• Added: SortOnDisk method.
• Added: BlockAutoFormat parameter to DumpToSheet method in order to prevent CSV injection.
• Added: AfterExportRecord, AfterImportRecord, AfterLoadStream,AfterSort and AfterWriteStream events.
• Bug fixed: Unable to detect opened workbooks.
• Bug fixed: Export procedure adding extra lines to output CSV files

CSVarrayList

• Added: error handling to Filter method.
• Added: LeftJoin, RightJoin, InnerJoin, Group, Reduce, AddIndexedItem, GetIndexedItem, RemoveIndexedItem, KeyExist and KeyIndex methods.
• Added: Indexing property.
• Optimized: RemoveRange, RemoveAt and Insert method.
• Bug fixed: Sort method.
• Deprecated: IntroSort sorting method.

CSVexpression

• Optimized: performance of evaluations on numerical expressions.
• Bug fixed: truncation of strings preventing assigment to string variables.