libStrings (String Processing Functions)

This file containts functions to deal with strings in VBA.

Summary

libStrings (String Processing Functions)	This file containts functions to deal with strings in VBA.
Constants
STRING_ERROR_NUMBER	The error number used for errors raised by the functions in this library.
Functions
replaceInString(target As String, replacee As String, replacer As String) As String	Replaces the first occurence of replacee within target with replacer and returns the resulting string.
getNumberFromString(s As String) As Integer	Returns the number that results, if all numeric characters in s are concatenated.
countDigitsInString(s As String) As Integer	Returns the number of digits within s.
incrementLastNumberInString(s As String, increment As Integer) As String	Increments the last number found in s by increment.

The error number used for errors raised by the functions in this library.

Public Function replaceInString( target As String,
replacee As String,
replacer As String ) As String

Replaces the first occurence of replacee within target with replacer and returns the resulting string.

result = replaceInString("monkey", "ke", "etar")

Public Function getNumberFromString( s As String ) As Integer

Returns the number that results, if all numeric characters in s are concatenated.

r = getNumberFromString("H12B24")

Public Function countDigitsInString( s As String ) As Integer

Returns the number of digits within s.

n = countDigitsInString("H12B24")

Public Function incrementLastNumberInString( s As String,
increment As Integer ) As String

Increments the last number found in s by increment.

r = incrementLastNumberInString("H12B24", 2)