A.19. String Manipulation
Asc Function
Returns a variant number representing the ANSI character of the first character of a string
AscB Function
Returns the value of the first byte in a string
AscW Function
Returns the native character code of the first character in a string (Unicode or ANSI)
Chr Function
Returns a variant string containing the character associated with the specified character code
Chr$ Function
Returns a string containing the character associated with the specified character code
ChrB Function
Returns a variant string containing the specified single byte
ChrB$ Function
Returns a string containing the specified single byte
ChrW Function
Returns a variant string containing the specified native character (Unicode or ANSI)
ChrW$ Function
Returns a string containing the specified native character (Unicode or ANSI)
Format Function
Returns a variant string formatted to a given specification
Format$ Function
Returns a string formatted to a given specification
FormatCurrency Function
Returns a string variant formatted using the currency settings for the current locale
FormatDateTime Function
Returns a string variant formatted using the date settings for the current locale
FormatNumber Function
Returns a numeric variant formatted to a specified format
FormatPercent Function
Returns a numeric variant formatted using the "%" symbol
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 first occurrence of a string within another string searching from the end of the string[5]
[5] VB6 only
Join Function
Returns a string constructed by concatenating an array of values with a given separator[6]
[6] VB6 only
LCase Function
Returns a variant string converted to lowercase
LCase$ Function
Returns a string converted to lowercase
Left Function
Returns a variant string containing the leftmost n characters of a string
Left$ Function
Returns a string containing the leftmost n characters of a string
LeftB Function
Returns a variant string containing the leftmost n bytes of a string
LeftB$ Function
Returns a 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 or needed to hold a given variable
LTrim Function
Returns a variant string with any leading spaces removed
LTrim$ Function
Returns a string with any leading spaces removed
Mid Function
Returns a variant substring containing a specified number of characters
Mid$ Function
Returns a substring containing a specified number of characters
MidB Function
Returns a variant string containing a specified number of bytes from a string
MidB$ Function
Returns a substring containing a specified number of bytes from a string
Replace Function
Returns a string where a specified value has been replaced with another given value[7]
[7] VB6 only
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
RightB$ Function
Returns a string containing the rightmost n bytes of a string
RTrim Function
Returns a variant string with any trailing spaces removed
RTrim$ Function
Returns a 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[8]
[8] for VB6 only
StrComp Function
Returns the result of a comparison of two strings
StrConv Function
Returns the result of converting a string
String Function
Returns a variant string containing a repeated character
String$ Function
Returns a string containing a repeated character
Trim Function
Returns a variant string with both leading and trailing spaces removed
Trim$ Function
Returns a string with both leading and trailing spaces removed
UCase Function
Returns a variant string converted to uppercase