In VBScript – Part 4, let’s see the following topics:
STRING FUNCTIONS:
Let’s see the syntax and example of some of the important String Functions:
UCase:
Converts a specified string to uppercase
Syntax:
|
1 |
UCase(string) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox ucase(str) |
Lcase:
Converts a specified string to lowercase
Syntax:
|
1 |
LCase(string) |
Example:
|
1 2 3 |
str = " Software Testing Material " msgbox str msgbox lcase(str) |
Len:
Returns the number of characters of a string
Syntax:
|
1 |
Len(string | varname) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox len(str) |
Replace:
Replaces a specified part of a string with another string a specified number of times
Syntax:
|
1 |
Replace(expression, find, replacewith[, start[, count[, compare]]]) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox replace(str, "A", "A", 1, 2,1) |
Space:
Returns a string that consists of a specified number of spaces
Syntax:
|
1 |
Space(number) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox str & space(10) & str |
Left:
Returns a specified number of characters from the left side of a string
Syntax:
|
1 |
Left(string, length) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox left(str, 5) |
Right:
Returns a specified number of characters from the right side of a string
Syntax:
|
1 |
Right(string, length) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox right(str, 5) |
Mid:
Returns a specified number of characters from a string
Syntax:
|
1 |
Mid(string, start[, length]) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox mid(str, 5, 9) |
Trim:
Removes spaces on both the left and the right side of a string
Syntax:
|
1 |
Trim(string) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox len(trim(str)) |
LTrim:
Removes spaces on the left side of a string
Syntax:
|
1 |
LTrim(string) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox len(ltrim(str)) |
RTrim:
Removes spaces on the right side of a string
Syntax:
|
1 |
RTrim(string) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox len(rtrim(str)) |
StrReverse:
It reverses a string
Syntax:
|
1 |
StrReverse(string) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox strreverse(str) |
InStr:
Returns the position of the first occurrence of one string within another
Syntax:
|
1 |
InStr([start, ]string1, string2[, compare]) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox instr(1,str, "Testing",1) |
InStrRev:
Returns the position of the first occurrence of one string within another. The search begins at the last character of the string
Syntax:
|
1 |
InStrRev(string1, string2[, start[, compare]]) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox instrrev(str, "Testing", len(str),1) |
StrComp:
Compares two strings and returns a value that represents the result of the comparison
Syntax:
|
1 |
StrComp(string1, string2[, compare]) |
Example:
|
1 2 3 4 |
dim str str = " Software Testing Material " msgbox str msgbox strcomp(str, "Testing",1) |
Split:
It returns an array that contains a specific number of values split based on a delimiter
Syntax:
|
1 |
Split(expression[, delimiter[, count[, compare]]]) |
Example:
|
1 2 3 4 5 6 7 |
dim str str = " Software Testing Material " msgbox str A=split(str) for i =0 to ubound(A) msgbox A(i) next |
DATE & TIME FUNCTIONS:
Let’s see the syntax and example of some of the important Date & Time Functions:
Now:
Returns the current system date and time
Syntax:
|
1 |
Now |
Example:
|
1 |
msgbox now |
Date:
Returns the current system date
Syntax:
|
1 |
Date |
Example:
|
1 |
msgbox date |
Time:
Returns the current system time
Syntax:
|
1 |
Time |
Example:
|
1 |
msgbox time |
DateAdd:
Returns a date to which a specified time interval has been added
Syntax:
|
1 |
DateAdd(interval, number, date) |
Example:
|
1 |
msgbox DateAdd("YYYY", 1, now) |
DateDiff:
Returns the number of intervals between two specified dates
Syntax:
|
1 |
DateDiff(interval, date1, date2 [,firstdayofweek[,firstweekofyear]]) |
Example:
|
1 |
msgbox DateDiff("YYYY", now, dateadd("YYYY", 1, now)) |
DatePart:
Returns the specified part of a given date
Syntax:
|
1 |
DatePart(interval, date[, firstdayofweek[, firstweekofyear]]) |
Example:
|
1 |
msgbox DatePart("YYYY",now) |
Day:
Returns a number that represents the day of the month
Syntax:
|
1 |
Day(date) |
Example:
|
1 |
msgbox day(now) |
Month:
Returns a number that represents the month of the year
Syntax:
|
1 |
Month(date) |
Example:
|
1 |
msgbox month(now) |
MonthName:
Returns the name of a specified month
Syntax:
|
1 |
MonthName(month[, abbreviate]) |
Example:
|
1 |
msgbox monthname(month(now)) |
Weekday:
Returns a number that represents the day of the week
Syntax:
|
1 |
Weekday(date, [firstdayofweek]) |
Example:
|
1 |
msgbox weekday(now) |
WeekdayName:
Returns the weekday name of a specified day of the week
Syntax:
|
1 |
WeekdayName(weekday, abbreviate, firstdayofweek) |
Example:
|
1 |
msgbox weekdayname(weekday(now)) |
Year:
Returns a number that represents the year
Syntax:
|
1 |
Year(date) |
Example:
|
1 |
msgbox year(now) |
Hour:
Returns a number that represents the hour of the day
Syntax:
|
1 |
Hour(time) |
Example:
|
1 |
msgbox hour(time) |
Minute:
Returns a number that represents the minute of the hour
Syntax:
|
1 |
minute(time) |
Example:
|
1 |
msgbox<span style="line-height: 1.5;"> minute(time)</span> |
Second:
Returns a number that represents the second of the minute
Syntax:
|
1 |
Second(time) |
Example:
|
1 |
msgbox second(time) |
TimeSerial:
Returns the time for a specific hour, minute, and second
Syntax:
|
1 |
TimeSerial(hour, minute, second) |
Example:
|
1 |
msgbox timeserial(2,00,1) |
TimeValue:
Returns a time
Syntax:
|
1 |
TimeValue(time) |
Example:
|
1 |
msgbox timevalue(time) |
I would like to conclude VBScript – Part 4 here and will start VBScript – Part 5 in the next post.
VBScript Series:
VBScript for Automation (QTP/UFT) Testing – Part 1
VBScript for Automation (QTP/UFT) Testing – Part 2
VBScript for Automation (QTP/UFT) Testing – Part 3
VBScript for Automation (QTP/UFT) Testing – Part 4
VBScript for Automation (QTP/UFT) Testing – Part 5
