Description: The String() function returns a string consisting a repeating characters of specified length. Format: String(number,character) Arguments: number Mandatory Type: Numeric No of times the character to be repeated, means length of the returned...
Description: The strComp() function compares the two strings and returns the comparison result in numeric form. Format: StrComp(string1, string2[, compare]) Arguments: String1 Mandatory Type: String First string which gets compared with another one
Description: The Space() function returns a string consisting a specified number of spaces. Format: Space (intNumberOfSpaces) Arguments: intNumberOfSpaces Mandatory Type: Numeric Number of spaces you want in the string.
Description: The Replace() function returns a string after replacing a part of string with another substring. The no of replacements depends on the parameters provided. Format: Replace(strMainString, find, replace[, start[, count[, compare]]]) Arguments: strMainString...
Description: The Mid() function returns substring from a string and size of the substring is decided based on the parameters provided. Format: Mid (strMainString,start[,length]) Arguments: strMainString Mandatory Type: String Substring will be returned from...
Description: The Len function returns the number of characters in a string including spaces. Format: Len (strMainString) Arguments: strMainString Mandatory Type: String String who’s both number of characters to be returned.
Description: The Trim function removes spaces on the left and right side of a string. Format: Trim (strMainString) Arguments: strMainString Mandatory Type: String String whose both side spaces needs to be trimmed.
Description: The RTrim function removes spaces on the right side of a string. Format: Rtrim (strMainString) Arguments: strMainString Mandatory Type: String String whose right space needs to be trimmed.
Description: The LTrim function removes spaces on the left side of a string. Format: Ltrim (strMainString) Arguments: strMainString Mandatory Type: String String whose left space needs to be trimmed.
Description: Returns a string containing number of characters specified by the user, starting from right side of the input string. Format: Right(strMainString,intLength) Arguments: strMainString Mandatory Type: String String whose characters to be returned.
Description: Returns a string containing number of characters specified by the user, starting from left side of the input string. Format: Left(strMainString,intLength,) Arguments: strMainString Mandatory Type: String String whose characters to be returned.
Description: This function converts the input string to Upper case. Format: UCase(strString) Arguments: strString Mandatory Type: String String whose characters to be converted in Upper case.
Description: This function converts the input string to lower case. Format: LCase(strString) Arguments: strString Mandatory Type: String String whose characters to be converted in Lower case.
Description: InstrRev: This function returns the position of last occurrence of a string into another string, as a variant, based upon the arguments are provided, OR you can say that it returns the position...
Description: Instr: This function returns the position of first occurrence of a string into another string, as a variant, based upon the arguments are provided. Format: InStr([start, ]mainString, searchedString[, compare]) Arguments: start Optional Type: ...