VBA-Strings

About

VBA-String is the most comprehensive library to-date for string manipulation in VBA and includes two modules:

• Strings.bas is an collection of string manipulation functions based on the ones provided by the .NET built-in String class.
• StringBuilder.cls is a custom class which offers superior performance when extensive string manipulation operations are required, and is based on the .NET built-in StringBuilder class.

All functions are additionally designed to use 0-based strings, providing an improved syntax in line with other languages.

Usage and Documentation

Refer to the About Strings and the About StringBuilder documentation.

Note this library is technically incomplete and may contain implementation errors - I have not had time to test all of the functions yet. I will at some point. If you find errors, pull requests are welcomed.

Inspiration & Reference

The functions in this library are based on .NET's String and StringBuilder classes. This library also incorporates a multitude of string functions included in other VBA string-related repositories, including Christian Buse's VBA-StringBuffer, Robert Todar's VBA-Strings, Bruce Mcpherson's cStringChunker, Peter Roach's clsStringBuilder and modString, Daniele Giaquinto's StringType, Frank Schwab's StringBuilder, and Greedquest's VBA-Gems.

For a full list of functions and how they line up with the functions from these other libraries, refer to the:

• Strings function table
• StringBuilder function table
• Other Libraries compatibility table