Simple VB script functions used for comparisons and calculation: -
1. CINT: Used for converting a value in to integer value
2.CSTR: It is used for
converting a value in to string
3.CDBL: It is used for converting a value in to Boolean value
4.CBOOL:It is used for converting any value in to Boolean value
5.LTRIM: It is used for trimming the left side spaces
6.RTRIM: It is used for trimming the right side spaces
7.TRIM: It is used for trimming the both side spaces
8.LEFT: It is used for getting the left side sub string
SYNTAX::var=left(string or variable, no of chars)
9.RIGHT: It is used for getting for right side sub string
SYNTAX::var= Right(string or variable, no of chars)
10.MID: It is used for getting the middle sub string
SYNTAX: var=mid (string or variable, starting char no, no
of chars)
11.UCASE: It is used for converting a string in to upper case
12.LCASE: It is used for converting a sting in to lower case
13.Round: It is used for rounding any decimal value to nearest
highest integer
No comments:
Post a Comment