StringBuilder Excel Class Module Reference Documentation

StringBuilder

Current Version: 9.5.0.90

A simple class for building strings. (Represents a mutable string of characters.)

Note: This class was introduced in Chilkat v9.5.0.58.

Object Creation

Dim oStringBuilder As Chilkat.StringBuilder
Set oStringBuilder = Chilkat.NewStringBuilder

Properties

IntValue
IntValue As Long
Introduced in version 9.5.0.58

Returns the content of the string converted to an integer.

top
IsBase64
IsBase64 As Long (read only)
Introduced in version 9.5.0.76

Returns True if the content contains only those characters allowed in the base64 encoding. A base64 string is composed of characters 'A'..'Z', 'a'..'z', '0'..'9', '+', '/' and it is often padded at the end with up to two '=', to make the length a multiple of 4. Whitespace is ignored.

top
LastMethodSuccess
LastMethodSuccess As Long

Indicate whether the last method call succeeded or failed. A value of True indicates success, a value of False indicates failure. This property is automatically set for method calls. It is not modified by property accesses. The property is automatically set to indicate success for the following types of method calls:

  • Any method that returns a string.
  • Any method returning a Chilkat object, binary bytes, or a date/time.
  • Any method returning a standard boolean status value where success = True and failure = False.
  • Any method returning an integer where failure is defined by a return value less than zero.

Note: Methods that do not fit the above requirements will always set this property equal to True. For example, a method that returns no value (such as a "void" in C++) will technically always succeed.

top
Length
Length As Long (read only)
Introduced in version 9.5.0.58

The number of characters of the string contained within this instance.

top

Methods

Append
Append(value As String) As Long
Introduced in version 9.5.0.58

Appends a copy of the specified string to this instance.

Returns True for success, False for failure.

top
AppendBd
AppendBd(binData As BinData, charset As String, offset As Long, numBytes As Long) As Long
Introduced in version 9.5.0.64

Appends the contents of binData. The charset specifies the character encoding of the bytes contained in binData. The charset can be any of the supported encodings listed at Chilkat Supported Character Encodings. To append the entire contents of binData, set offset and numBytes equal to zero. To append a range of binData, set the offset and numBytes to specify the range.

Returns True for success, False for failure.

top
AppendInt
AppendInt(value As Long) As Long
Introduced in version 9.5.0.58

Appends the string representation of a specified 32-bit signed integer to this instance.

Returns True for success, False for failure.

top
AppendLine
AppendLine(value As String, crlf As Boolean) As Long
Introduced in version 9.5.0.65

Appends the value followed by a CRLF or LF to the end of the curent StringBuilder object. If crlf is True, then a CRLF line ending is used. Otherwise a LF line ending is used.

Returns True for success, False for failure.

top
AppendSb
AppendSb(sb As StringBuilder) As Long
Introduced in version 9.5.0.62

Appends the contents of another StringBuilder to this instance.

Returns True for success, False for failure.

top
Clear
Clear()
Introduced in version 9.5.0.58

Removes all characters from the current StringBuilder instance.

top
Contains
Contains(str As String, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.58

Returns True if the str is contained within this object. For case sensitive matching, set caseSensitive equal to True. For case-insensitive, set caseSensitive equal to False.

top
ContainsWord
ContainsWord(word As String, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.69

Returns True if the word is contained within this object, but only if it is a whole word. This method is limited to finding whole words in strings that only contains characters in the Latin1 charset (i.e. iso-8859-1 or Windows-1252). A whole word can only contain alphanumeric chars where the alpha chars are restricted to those of the Latin1 alpha chars. (The underscore character is also considered part of a word.)

For case sensitive matching, set caseSensitive equal to True. For case-insensitive, set caseSensitive equal to False.

top
ContentsEqual
ContentsEqual(str As String, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.62

Returns True if the contents of this object equals the str. Returns False if unequal. For case insensitive equality, set caseSensitive equal to False.

top
ContentsEqualSb
ContentsEqualSb(sb As StringBuilder, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.62

Returns True if the contents of this object equals the sb. Returns False if unequal. For case insensitive equality, set caseSensitive equal to False.

top
Decode
Decode(encoding As String, charset As String) As Long
Introduced in version 9.5.0.62

Decodes and replaces the contents with the decoded string. The encoding can be set to any of the following strings: "base64", "hex", "quoted-printable" (or "qp"), "url", "base32", "Q", "B", "url_rc1738", "url_rfc2396", "url_rfc3986", "url_oauth", "uu", "modBase64", or "html" (for HTML entity encoding). The full up-to-date list of supported binary encodings is available at the link entitled "Supported Binary Encodings" below.

Note: This method can only be called if the encoded content decodes to a string. The charset indicates the charset to be used in intepreting the decoded bytes. For example, the charset can be "utf-8", "utf-16", "iso-8859-1", "shift_JIS", etc.

Returns True for success, False for failure.

top
DecodeAndAppend
DecodeAndAppend(value As String, encoding As String, charset As String) As Long
Introduced in version 9.5.0.87

Decodes a binary encoded string, where the binary encoding (such as "url", "hex", "base64", etc.) is specified by encoding, and the underlying charset encoding (such as "utf-8", "windows-1252", etc.) is specified by charset. The decoded string is appended to this object.

Returns True for success, False for failure.

More Information and Examples
top
Encode
Encode(encoding As String, charset As String) As Long
Introduced in version 9.5.0.62

Encodes to base64, hex, quoted-printable, URL encoding, etc. The encoding can be set to any of the following strings: "base64", "hex", "quoted-printable" (or "qp"), "url", "base32", "Q", "B", "url_rc1738", "url_rfc2396", "url_rfc3986", "url_oauth", "uu", "modBase64", or "html" (for HTML entity encoding). The full up-to-date list of supported binary encodings is available at the link entitled "Supported Binary Encodings" below.

Returns True for success, False for failure.

top
EndsWith
EndsWith(substr As String, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.62

Returns True if the string ends with substr. Otherwise returns False. The comparison is case sensitive if caseSensitive is True, and case insensitive if caseSensitive is False.

top
EntityDecode
EntityDecode() As Long
Introduced in version 9.5.0.62

Decodes HTML entities. See HTML entities for more information about HTML entities.

Returns True for success, False for failure.

More Information and Examples
top
GetAfterBetween
GetAfterBetween(searchAfter As String, beginMark As String, endMark As String) As String
Introduced in version 9.5.0.62

Begin searching after the 1st occurrence of searchAfter is found, and then return the substring found between the next occurrence of beginMark and the next occurrence of endMark.

Returns Nothing on failure

top
GetAfterFinal
GetAfterFinal(marker As String, removeFlag As Boolean) As String
Introduced in version 9.5.0.77

Returns the substring found after the final occurrence of marker. If removeFlag is True, the marker and the content that follows is removed from this content.

If the marker is not present, then the entire string is returned. In this case, if removeFlag is True, this object is also cleared.

Returns Nothing on failure

More Information and Examples
top
GetAsString
GetAsString() As String
Introduced in version 9.5.0.58

Returns the contents as a string.

Returns Nothing on failure

top
GetBefore
GetBefore(marker As String, removeFlag As Boolean) As String
Introduced in version 9.5.0.77

Returns the substring found before the 1st occurrence of marker. If removeFlag is True, the content up to and including the marker is removed from this object's contents.

If the marker is not present, then the entire string is returned. In this case, if removeFlag is True, this object is also cleared.

Returns Nothing on failure

More Information and Examples
top
GetBetween
GetBetween(beginMark As String, endMark As String) As String
Introduced in version 9.5.0.62

Returns the substring found between the 1st occurrence of beginMark and the next occurrence of endMark.

Returns Nothing on failure

More Information and Examples
top
GetEncoded
GetEncoded(encoding As String, charset As String) As String
Introduced in version 9.5.0.62

Returns the string contents encoded in an encoding such as base64, hex, quoted-printable, or URL-encoding. The encoding can be set to any of the following strings: "base64", "hex", "quoted-printable" (or "qp"), "url", "base32", "Q", "B", "url_rc1738", "url_rfc2396", "url_rfc3986", "url_oauth", "uu", "modBase64", or "html" (for HTML entity encoding). The full up-to-date list of supported binary encodings is available at the link entitled "Supported Binary Encodings" below.

Note: The Encode method modifies the content of this object. The GetEncoded method leaves this object's content unmodified.

Returns Nothing on failure

top
GetNth
GetNth(index As Long, delimiterChar As String, exceptDoubleQuoted As Boolean, exceptEscaped As Boolean) As String
Introduced in version 9.5.0.62

Returns the Nth substring in string that is a list delimted by delimiterChar. The first substring is at index 0. If exceptDoubleQuoted is True, then the delimiter char found between double quotes is not treated as a delimiter. If exceptEscaped is True, then an escaped (with a backslash) delimiter char is not treated as a delimiter.

Returns Nothing on failure

More Information and Examples
top
GetRange
GetRange(startIndex As Long, numChars As Long, removeFlag As Boolean) As String
Introduced in version 9.5.0.87

Returns a string containing the specified range of characters from this instance. If removeFlag is True, then the range of chars is removed from this instance.

Note: It was discovered that the range of chars was always removed regardless of the value of removeFlag. This is fixed in v9.5.0.89.

Returns Nothing on failure

More Information and Examples
top
LastNLines
LastNLines(numLines As Long, bCrlf As Boolean) As String
Introduced in version 9.5.0.62

Returns the last N lines of the text. If fewer than numLines lines exists, then all of the text is returned. If bCrlf is True, then the line endings of the returned string are converted to CRLF, otherwise the line endings are converted to LF-only.

Returns Nothing on failure

More Information and Examples
top
LoadFile
LoadFile(path As String, charset As String) As Long
Introduced in version 9.5.0.62

Loads the contents of a file.

Returns True for success, False for failure.

top
Obfuscate
Obfuscate()
Introduced in version 9.5.0.80

Obfuscates the string. (The Unobfuscate method can be called to reverse the obfuscation to restore the original string.)

The Chilkat string obfuscation algorithm works by taking the utf-8 bytes of the string, base64 encoding it, and then scrambling the letters of the base64 encoded string. It is deterministic in that the same string will always obfuscate to the same result. It is NOT a secure way of encrypting a string. It is only meant to be a simple means of transforming a string into something unintelligible.

More Information and Examples
top
Prepend
Prepend(value As String) As Long
Introduced in version 9.5.0.61

Prepends a copy of the specified string to this instance.

Returns True for success, False for failure.

top
PunyDecode
PunyDecode() As Long
Introduced in version 9.5.0.71

In-place decodes the string from punycode.

Returns True for success, False for failure.

top
PunyEncode
PunyEncode() As Long
Introduced in version 9.5.0.71

In-place encodes the string to punycode.

Returns True for success, False for failure.

top
RemoveAfterFinal
RemoveAfterFinal(marker As String) As Long
Introduced in version 9.5.0.77

Removes the substring found after the final occurrence of the marker. Also removes the marker. Returns True if the marker was found and content was removed. Otherwise returns False.

Returns True for success, False for failure.

More Information and Examples
top
RemoveBefore
RemoveBefore(marker As String) As Long
Introduced in version 9.5.0.77

Removes the substring found before the 1st occurrence of the marker. Also removes the marker. Returns True if the marker was found and content was removed. Otherwise returns False.

Returns True for success, False for failure.

More Information and Examples
top
RemoveCharsAt
RemoveCharsAt(startIndex As Long, numChars As Long) As Long
Introduced in version 9.5.0.87

Removes the specified range of characters from this instance.

Returns True for success, False for failure.

More Information and Examples
top
Replace
Replace(value As String, replacement As String) As Long
Introduced in version 9.5.0.58

Replaces all occurrences of a specified string in this instance with another specified string. Returns the number of replacements.

top
ReplaceAfterFinal
ReplaceAfterFinal(marker As String, replacement As String) As Long
Introduced in version 9.5.0.73

Replaces the content found after the final occurrence of marker with replacement.

Returns True for success, False for failure.

top
ReplaceAllBetween
ReplaceAllBetween(beginMark As String, endMark As String, replacement As String, replaceMarks As Boolean) As Long
Introduced in version 9.5.0.64

Replaces the first occurrence of ALL the content found between beginMark and endMark with replacement. The beginMark and endMark are included in what is replaced if replaceMarks is True.

Returns True for success, False for failure.

top
ReplaceBetween
ReplaceBetween(beginMark As String, endMark As String, value As String, replacement As String) As Long
Introduced in version 9.5.0.62

Replaces all occurrences of value with replacement, but only where value is found between beginMark and endMark. Returns the number of replacements made.

More Information and Examples
top
ReplaceFirst
ReplaceFirst(value As String, replacement As String) As Long
Introduced in version 9.5.0.77

Replaces the first occurrence of a specified string in this instance with another string. Returns True if the value was found and replaced. Otherwise returns False.

Returns True for success, False for failure.

More Information and Examples
top
ReplaceI
ReplaceI(value As String, replacement As Long) As Long
Introduced in version 9.5.0.67

Replaces all occurrences of value with the decimal integer replacement. Returns the number of replacements.

top
ReplaceNoCase
ReplaceNoCase(value As String, replacement As String) As Long
Introduced in version 9.5.0.82

Replaces all occurrences of value with replacement (case insensitive). Returns the number of replacements.

top
ReplaceWord
ReplaceWord(value As String, replacement As String) As Long
Introduced in version 9.5.0.62

Replaces all word occurrences of a specified string in this instance with another specified string. Returns the number of replacements made.

Important: This method is limited to replacing whole words in strings that only contains characters in the Latin1 charset (i.e. iso-8859-1 or Windows-1252). A whole word can only contain alphanumeric chars where the alpha chars are restricted to those of the Latin1 alpha chars. (The underscore character is also considered part of a word.)

More Information and Examples
top
SecureClear
SecureClear()
Introduced in version 9.5.0.67

Removes all characters from the current StringBuilder instance, and write zero bytes to the allocated memory before deallocating.

top
SetNth
SetNth(index As Long, value As String, delimiterChar As String, exceptDoubleQuoted As Boolean, exceptEscaped As Boolean) As Long
Introduced in version 9.5.0.62

Sets the Nth substring in string in a list delimted by delimiterChar. The first substring is at index 0. If exceptDoubleQuoted is True, then the delimiter char found between double quotes is not treated as a delimiter. If exceptEscaped is True, then an escaped (with a backslash) delimiter char is not treated as a delimiter.

Returns True for success, False for failure.

More Information and Examples
top
SetString
SetString(value As String) As Long
Introduced in version 9.5.0.61

Sets this instance to a copy of the specified string.

Returns True for success, False for failure.

top
Shorten
Shorten(numChars As Long) As Long
Introduced in version 9.5.0.87

Shortens the string by removing the last numChars chars.

Returns True for success, False for failure.

More Information and Examples
top
StartsWith
StartsWith(substr As String, caseSensitive As Boolean) As Long
Introduced in version 9.5.0.62

Returns True if the string starts with substr. Otherwise returns False. The comparison is case sensitive if caseSensitive is True, and case insensitive if caseSensitive is False.

top
ToCRLF
ToCRLF() As Long
Introduced in version 9.5.0.62

Converts line endings to CRLF (Windows) format.

Returns True for success, False for failure.

top
ToLF
ToLF() As Long
Introduced in version 9.5.0.62

Converts line endings to LF-only (UNIX) format.

Returns True for success, False for failure.

top
ToLowercase
ToLowercase() As Long
Introduced in version 9.5.0.62

Converts the contents to lowercase.

Returns True for success, False for failure.

top
ToUppercase
ToUppercase() As Long
Introduced in version 9.5.0.62

Converts the contents to uppercase.

Returns True for success, False for failure.

top
Trim
Trim() As Long
Introduced in version 9.5.0.62

Trims whitespace from both ends of the string.

Returns True for success, False for failure.

top
TrimInsideSpaces
TrimInsideSpaces() As Long
Introduced in version 9.5.0.62

Replaces all tabs, CR's, and LF's, with SPACE chars, and removes extra SPACE's so there are no occurances of more than one SPACE char in a row.

Returns True for success, False for failure.

top
Unobfuscate
Unobfuscate()
Introduced in version 9.5.0.80

Unobfuscates the string.

The Chilkat string obfuscation algorithm works by taking the utf-8 bytes of the string, base64 encoding it, and then scrambling the letters of the base64 encoded string. It is deterministic in that the same string will always obfuscate to the same result. It is not a secure way of encrypting a string. It is only meant to be a simple means of transforming a string into something unintelligible.

More Information and Examples
top
WriteFile
WriteFile(path As String, charset As String, emitBom As Boolean) As Long
Introduced in version 9.5.0.62

Writes the contents to a file. If emitBom is True, then the BOM (also known as a preamble), is emitted for charsets that define a BOM (such as utf-8, utf-16, utf-32, etc.)

Returns True for success, False for failure.

top
WriteFileIfModified
WriteFileIfModified(path As String, charset As String, emitBom As Boolean) As Long
Introduced in version 9.5.0.73

Writes the contents to a file, but only if it is a new file or if the contents are different than the existing file. If emitBom is True, then the BOM (also known as a preamble), is emitted for charsets that define a BOM (such as utf-8, utf-16, utf-32, etc.)

Returns True for success, False for failure.

top