Section A.21. String Manipulation


A.21. String Manipulation

Element

Description

Asc, AscW Functions

Returns the character code of the first character of a string

Chr, ChrW Functions

Returns a string containing a character based on its numeric code

Filter Function

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

Format Function

Returns a string formatted to a given specification

FormatCurrency, FormatNumber, FormatPercent Functions

Returns a numeric value formatted as indicated by the name of the specific function

FormatDateTime Function

Returns a string formatted using the date/time setting for the current locale

GetChar Function

Returns a Char containing the character at a particular position in a string

InStr Function

Finds the starting position of a substring within a string

InStrRev Function

Returns the first occurrence of a string within another string by searching from the end of the string

Join Function

Concatenates an array of values into a delimited string

LCase Function

Converts a character or string to lowercase

Left Function

Returns a string containing a specific number of characters from the beginning of a string

Len Function

Counts the number of characters in a string

Like Operator

Compares two strings

LSet Function

Left-aligns a string

LTrim Function

Removes characters from the beginning of a string

Mid Function

Extracts a substring from a larger string

Mid Statement

Replaces a substring in a larger string

Option Compare Statement

Sets the default method for comparing string data

Replace Function

Replaces one or more occurrences of a substring within a larger string

Right Function

Returns a string containing a specific number of characters from the end of a string

RSet Function

Right-aligns a string

RTrim Function

Removes characters from the end of a string

Str Function

Converts a numeric value to a string

SPC Function

Inserts spaces between expressions in output

Space Function

Fills a string with a given number of spaces

Split Function

Returns an array of strings from a single delimited string

StrComp Function

Returns the result of comparing two strings

StrConv Function

Returns the result of converting a string in a number of possible ways

StrDup Function

Returns a string consisting of the first character of another string duplicated a given number of times

StrReverse Function

Reverses the characters of a string

Trim Function

Removes characters from the beginning and end of a string

UCase Function

Converts a string to uppercase

Val Function

Converts a numeric string to a number

VBFixedString Attribute

Defines a fixed-length string





Visual Basic 2005(c) In a Nutshell
Visual Basic 2005 in a Nutshell (In a Nutshell (OReilly))
ISBN: 059610152X
EAN: 2147483647
Year: 2004
Pages: 712

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net