Text functions

Text functions

In this section you can find VBA functions and subroutines to operate on strings.

The functions are listed below:

Function to return only digits from the given String (`onlyDigits`)

Function to check if the given String starts with the specified substring (`startsWith`)

Function to check if the given String ends with the specified substring (`endsWith`)

Function to remove all the blank characters from the given string (`removeSpaces`)

Function to print the given content (String or array) into the specified textfile (`printToTextFile`)

Function to return the symbol of a column with the specified index number (`columnHeader`)

Function to return the substring of a source string between given delimiters (`substring`)

Function to check whether the given character is a digit (`isDigit`)

Function to count how many times a string appears within another string (`countOccurrences`)

Function add leading zeros to the given number until it reaches the specified length (`addLeadingZeros`)

Function to convert the first letter of the given String to upper case (`startsWithUpper`)

Function to cut the specified number of characters at the end of the given string (`cutChars`)

Function to check if the given value is a non-empty String (`isNonEmptyString`)

Function to convert the given value into String (`stringify`)

Function to compare more than two strings to each other (`compareStrings`)

Function to compare two strings (`compareString`)

Function to check if the given string contain any of substring (`containsAny`)

Function to create string from the given pattern and set of values (`formatString`)

Function to check if two given strings starts with the same substring (`equalStart`)

Function to check if two given strings ends with the same substring (`equalEnd`)

Function to check if the given value is between two limit values (`inRange`)

Function to split the given string into array of strings with empty values excluded (`splitWithoutEmpties`)

Function to check if the given value is an empty string (`isEmptyString`)

Function to check if the given text contains the given substring (`contains`)