Section A.15. String Manipulation

Asc Function

Returns a number representing the ASCII character of the first character of a string

AscB Function

Returns the value of the first byte in a string

AscW Function

Returns the Unicode character code of the first character in a string

Chr Function

Returns a string containing the character associated with the specified character code

ChrB Function

Returns a string containing the specified single byte

ChrW Function

Returns a string with the character that corresponds to a particular Unicode character code

Escape Function

Returns an encoded version of a string

Execute Method

Performs a regular expression search on a string

Filter Function

Returns an array of strings matching (or not) a specified value

FirstIndex Property

Returns the starting position in a search string where a regular expression match represented by a Match object occurred.

FormatCurrency Function

Returns a string formatted using the currency settings for the current locale

FormatDateTime Function

Returns a string formatted using the date settings for the current locale

FormatNumber Function

Returns a number formatted to a specified format

FormatPercent Function

Returns a number formatted using the % symbol

Global Property

Indicates whether a RegExp object's pattern should match all occurrences in a search string or just one

IgnoreCase Property

Indicates whether a RegExp object's pattern match should be case-insensitive

InStr Function

Returns the position of the first occurrence of one string within another

InStrB Function

Returns the byte position of the first occurrence of one string in another

InStrRev Function

Returns the last occurrence of a string within another string

Join Function

Returns a string constructed by concatenating an array of values with a given separator

LCase Function

Returns a variant string converted to lowercase

Left Function

Returns a variant string containing the leftmost n characters of a string

LeftB Function

Returns a variant string containing the leftmost n bytes of a string

Len Function

Returns the length of a given string

LenB Function

Returns the number of bytes in a given string

Length Property

Returns the length of a match represented by a Match object in a search string

LTrim Function

Returns a variant string with any leading spaces removed

Match Object

Represents a single match from a regular expression search

Matches Collection

Contains all the Match objects representing the matches found in a regular expression search

Mid Function

Returns a variant substring containing a specified number of characters

MidB Function

Returns a variant string containing a specified number of bytes from a string

Pattern Property

Sets or returns the pattern that the RegExp object attempts to find in its search string

RegExp Object

An object designed to provide regular expression support

Replace Function

Returns a string where a specified value has been replaced with another given value

Replace Method

Replaces substrings found in a regular expression search

Right Function

Returns a variant string containing the rightmost n characters of a string

RightB Function

Returns a variant string containing the rightmost n bytes of a string

RTrim Function

Returns a variant string with any trailing spaces removed

Space Function

Returns a variant string consisting of the specified number of spaces

Split Function

Returns an array of values derived from a single string and a specified separator

StrComp Function

Returns the result of a comparison of two strings

String Function

Returns a variant string containing a repeated character

StrReverse Function

Returns the reverse of a string

Test Method

Indicates whether a match was found in a RegExp object search

Trim Function

Returns a variant string with both leading and trailing spaces removed

UCase Function

Returns a variant string converted to uppercase

Unescape Function

Decodes a URL- or HTML-encoded string

Value Property

Returns the text of a regular expression match represented by a Match object