Here is a link that is a good read for understanding Functions in VB6. After reading your comment, I would create a class to store your values. Public Class MyClass Dim name As String Dim dept As String Dim country As String End Class Then, you can instantiate a new instance of this class inside of your code. VBScript Functions Previous Next. String Functions. Function Description; InStr: Returns the position of the first occurrence of one string within another. The string Functions allows us to work with strings, as it's clear from their name. 1) Lcase and Ucase Functions Explanation: Converts string to Lower and Upper case respectively. Syntax: LCase(String) UCase(String) Example: Print Lcase('NiKhIl') ' The Output is: 'nikhil' Print UCase('grEen') ' The Output is: 'GREEN' 2) Len Function Explanation: Returns length of string, simple. Syntax: Len(String) Example: Print Len('Green Day') 'The Output is 9 3) Trim, Ltrim, Rtrim (i) Trim - Removes Leading and trailing spaces. (ii) Ltrim - Removes leading spaces. (iii) Rtrim - Removes trailing spaces. NOTE: all of these DO NOT effect spaces BETWEEN the words. Syntax: Ltrim(String) Rtrim(String) Trim(String) Example: Print Trim(' Beautiful Day ') 'Output is 'Beautiful Day' Print Ltrim(' Beautiful Day ') 'Output is 'Beautiful Day ' Print Rtrim(' Beautiful Day ') 'Output is ' Beautiful Day' 'IMP: Carefully notice the spaces in OUTPUTs. 4) Left And right functions: Explanation: Extracts some no. Of characters from LEFTMOST and RIGHTMOST portion of a string respectively. Postgres serial column. Syntax: Left(String, Number-Of-Chars) RIght(String, Number-Of-Chars) Example: Print Left('The Offspring Rocks',5) ' Output is 'The O' Print Right('The Offspring Rocks',4) 'Output is 'ocks' 5)Mid Function Explanation: Extracts some character from ANY portion of the string. Syntax: MID(String, Start-Position, Number-Of-Chars) Example: Print MID('Basket Case',3,2) ' The Output is 'sk' 6) Instr Fuction Explanation: THis function searches string within strings, i.e., returns location of a string within string. Syntax: Instr(start-postion, string-in-which-searchin, string-to-search-for) Explanation: Print InStr(1, 'Brain Stew', 'ain') ' The OutPut is 3 7) Space Function Explanation: Produces Number of Spaces, easy. Syntax: Space(no-of-spaces-to-be-generated) Example: Print 'Hi' & Space(5) & 'There' 'Output is 'Hi There' 8) String Function Explanation: Generate particular no of characters. Syntax: String(number-of-times, character) Example: Print String(10, 'A') 'The Output is 'AAAAAAAAAA' 9) Str Function Explanation: Converts a number in equivalent string. Syntax: Str(number) Example: Print Str(-155) 'Output is '-155' 10) Asc Function Explanation: Returns Ascii code of a character. Syntax: Asc(String) Example: Asc('F') 'Output is 70 Asc('Dessloch') 'Output is 68 as ascii code of 'D' is 68 'NOTE: In multi charactered string, it prints ascii code of first letter without any error 10) StrReverse Function Explanation: Returns the string, INVERTED. Syntax: StrReverse(String) Example: StrReverse('ABCD') 'Output is 'DCBA' =============END================ whoa, lots of Typing! Strings are a sequence of characters, which can consist of either alphabets, numbers, special characters, or all of them. A variable is said to be a string if it is enclosed within double quotes ' '. Syntax variablename = 'string' Examples str1 = 'string' ' Only Alphabets str2 = '132.45' ' Only Numbers str3 = '!@#$;*' ' Only Special Characters Str4 = 'Asc23@#' ' Has all the above String Functions There are predefined VBA String functions, which help the developers to work with the strings very effectively. Following are String methods that are supported in VBA. Please click on each one of the methods to know in detail. Function Name & Description 1 Returns the first occurrence of the specified substring. Search happens from the left to the right.
0 Comments
Leave a Reply. |