Low cost ecommerce web development India flash website design 

String Functions

§ UCase(string) returns string with all its lowercase letters converted to

uppercase letters.

§ LCase(string) returns string with all its uppercase letters converted to

lowercase letters.

§ LTrim(string) removes all the spaces from the left side of string.

§ RTrim(string) removes all the spaces from the right side of string.

§ Trim(string) removes spaces from both the left and the right sides.

§ Space(number) returns a string consisting of number spaces.

§ String(number, character) returns a string consisting of character

repeated number times.

§ Len(string) returns the number of characters in string.

§ Len(variable) returns the number of bytes required by variable.

§ LenB(string) returns the number of bytes required to store string.

§ StrReverse(string) returns string with the characters in reverse order.

§ StrComp(string1,string2,comparetype) is used to perform string

comparisons. If comparetype is zero or omitted, the two strings are

compared as if uppercase letters come before lowercase letters. If

comparetype is one, the two strings are compared as if upper and

lowercase letters are the same. StrComp returns -1 if string1 is less than

47

string2. It returns 0 if they are the same, and 1 if string1 is greater than

string2.

§ Right(string,number) returns the number rightmost characters of string.

§ RightB(string,number) works like Right, but number is taken to be a

number of bytes rather than characters.

§ Left(string,number), as you may guess, returns the number leftmost

characters of string.

§ LeftB(string,number) works like Left, but number is taken to be a

number of bytes rather than characters.

§ Mid(string,start,length) returns length characters from string,

starting at position start. When length is greater than the number of

characters left in the string, the rest of the string is returned. If length is not

specified, the rest of the string starting at the specified starting position is

returned.

§ MidB(string,start,length) works like Mid, but start and length are

both taken to be byte numbers rather than character numbers.

§ InStr(start,stringi,strlng2,comparetype) is used to check if and

where string2 occurs within string1. Start is an optional argument

that specifies where in string1 to start looking for string2.

comparetype is an optional argument that specifies which type of

comparison to perform. If comparetype is 0, a binary comparison is performed,

and uppercase letters are distinct from lowercase letters. If

comparetype is 1, a textual comparison is performed, and uppercase and

lowercase letters are the same. InStr returns zero if string1 is empty

(""), if string2 is not found in string1, or if start is greater than the

length of string2. It returns Null if either string is Null, It returns start

if string2 is empty. If string2 is successfully found in string1, it

returns the starting position where it is first found.

§ InStrB works like InStr except that the start position and return value

are byte positions, not character positions.

§ InStrRev(string1,string2,start,comparetype) starts looking for a

match at the right side of the string rather than the left side. start is by

default -1, which means to start at the end of the string.

§ Replace(string,find,replace,start,count,comparetype) is used to

replace occurrences of find with replace in string. start, count, and

comparetype are optional, but if you want to use one, you must use the

ones that come before it. start indicates where the resulting string will

start and where to start searching for find. It defaults to 1. count indicates

how many times to perform the replacement. By default, count is -1,

which means to replace every occurrence. If comparetype is 0, a binary

comparison is performed, and uppercase letters are distinct from lowercase

letters. If comparetype is 1, a textual comparison is performed, and

uppercase and lowercase letters are the same.

§ Filter(arrStrings,SearchFor,include,comparetype) searches an

array of strings, arrStrings, and returns a subset of the array, include is

a Boolean value. If include is True, Filter searches through all the

strings in arrStrings and returns an array containing the strings that

contain SearchFor. If include is False, Filter returns an array of the

strings that do not contain SearchFor. include is optional and defaults

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73