String functions:
LCase() function:
Return a string that has been passed to it as
an augment convert it to lowercase string
LCase(String)
e.g LCase(“PRATIK”) returns “pratik”
UCase() function:
Return a string that have been passed to it as
an argument converted to uppercase string
UCase(string)
e.g UCase(“pratik”) returns “PRATIK”
Len( string):
Gives the length of the string which is passed to
it as an argument.
e.g Len(“Pratik”) gives 6
LTRIM( string)
Return the string without any leading spaces
e.g Print LTRIM(“ BSC ”) gives
“BSC ”
RTRIM(string)
Return the string without any trailing spaces
e.g Print RTRIM(“ BSC ”) gives “
BSC”
TRIM(string)
Return string without any leading or trailing
spaces.
e.g Print TRIM(“ BSC ”) gives “BSC”
LEFT(String, length)
Return the specified number of characters
from the left side of this string.
e.g Print LEFT(“Bajaj College of Science”, 5) gives
“Bajaj”
RIGHT(String, length)
Return the specified number of character from the
right side of the screen
e.g Print RIGHT (“Bajaj College of Science”, 7)
gives “Science”
MID(String, Start,Length)
Return the specified number of characters from the
specified position of the string
e.g print MID (“Bajaj College of Science”, 7, 7)
gives “College”
CHR(charcode)
Return the character associated with the specified
ASCII number.
e.g Print CHR(65) return “A”
ASC(String)
Return the ASCII number for the first letter in the
string.
e.g Print ASC(“A”) return 65
InStr() Function
It is used to find the occurrence of the one string
inside other string along with the position of it.
Return a Long value specifying the position of the
first occurrence of the one string in another.
Syntax:
InStr(String1, String2)
e,g print Instr(“Pratik” , “a”) return 2 which
is the position of string “a” in the string Pratik.
StrComp() Function:
Return a(Variant) integer indicating the result of
the string comparison.
e.g StrComp(String1, String2)
Function returns an integer value depending on the
result of the comparison as follows
|
String1 is less than string2
|
-1
|
|
String 1 is equal to string 2
|
0
|
|
String 1 greater than string 2
|
1
|
|
Sting 1 or string to is Null
|
Null
|
While comparing the two string the ASCII values of
the character in it are compared
e.g StrComp(“Pratik”,
“pratik”) gives -1
StrComp(“Pratik”,
“Pratik”) gives 0
StrComp(“Prashant”,
“Pratik”) gives 1
