The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
To prove that we are capable to unlocks some performance limitations from traditional file processing approach, I decided to develop the CSVTextStream to gain advantage over native VBA's I/O functionalities, boosting the efficiency of text file reading up to 2 GB in size by use a buffered text stream technique. You can download the latest version from here.
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
The table below shows the overall performance for the read operations, you can download the test files from here. The test machine is running Win 10 Pro 64-bit, Intel® Core™ i7-4500U CPU N2600 @1.80 GHz - 2.40 GHz, 8 GB RAM.
Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.
Removing all blank lines at the end of a text file
1 project | /r/vba | 17 Feb 2023
[Access] Any alternatives to Scripting.TextStream that eat up less memory?
1 project | /r/vba | 25 May 2022
Advanced CSV filtering through VBA
2 projects | /r/vba | 6 Mar 2022
Evaluating expressions from strings in VBA
4 projects | /r/vba | 20 Feb 2022
What have you been working on? (Week of January 29, 2021)
1 project | /r/vba | 30 Jan 2021