ECPTextStream
VBA
Our great sponsors
| ECPTextStream | VBA | |
|---|---|---|
| 5 | 1 | |
| 11 | 407 | |
| - | - | |
| 0.0 | 0.0 | |
| about 1 year ago | about 1 year ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ECPTextStream
-
Meet a library member: CSVTextStream, the king of performance.
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.
-
Removing all blank lines at the end of a text file
This is a perfect use case for ECPTextStream. Create a loop for read the source text file and write the result file. Inside the file loop, manage to handle the last chunk of information and remove the last char until a line break is found.
-
[Access] Any alternatives to Scripting.TextStream that eat up less memory?
Maybe the ECPTextStream class module can help you. This library is faster than the scripting method when dealing with text files and can manage files up to 2GB without any problem. See the benchmarks here.
-
VBA CSV Interface v3 Pre-release
Parse CSV/TSV through streams with the ECPTextStream class module.
-
What have you been working on? (Week of January 29, 2021)
New versión of the VBA-CSV Interface class. This will integrate the ECPTextStream class module in order to reduce memory overloads when retrieving few records from a CSV file.
VBA
-
How easy is it to switch industries?
Lots of stock/option trading stuff. Detailed web scrapers. Couple games. Some bioinformatic algorithms. I don’t have em on my website but I automated all the web pages in vba (which is why it isn’t a great website but I’m also not a website developer). So my site and GitHub are good ways to get sample code out there.
What are some alternatives?
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
Excel-Pomodoro-Timer - Excel Pomodoro Timer
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
JustMoreVBA - A collection of code snippets, modules, and classes that I've written and collected over the years.
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
add-chatgpt-to-microsoft-word - How to add ChatGPT's Text Completion to Microsoft Word
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
vba-macros - Some VBA macros for personal use
msaccess-vcs-addin - Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
Speed-Bionic-Reading - Speed reading technique that has recaptured public interest due to Bionic Reading done in a VBA Macro
integrate-palm-into-word - How to use Google's PaLM 2 language model in Microsoft Word.
VBAIPFunctions - IP manipulation and lookup VBA functions