VBScript for Automation (QTP/UFT) Testing – Part 4

VBScript for Automation (QTP/UFT) Testing – Part 4

In VBScript – Part 4, let’s see the following topics:

String Functions
Date & Time

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

Back To Top