1. Difference between Instr and Instrrev
Ans: Syntax is slightly different
dim str
str="accenture"
'CASE 1:
msgbox Instr(1,str,t)
=>6
msgbox InstrRev(1,str,t)
=>6
'CASE 2:
msgbox Instr(1,str,"c")
=>2
msgbox InstrRev(1,str,"c")
=>3
#If string to be searched exists only one in provided string then index will be same.
#If more than one occurrence then Instrrev will give index of string from right to left
2. Select all names which begins with "a" in excel file with column emp name using adodb
3. Adodb fields and values
4. Regular expression question
5. FSO: from a file how many times character is repeated
6. Find how many times c appears in word "accenture"
7. Ordinal Identifiers
8. Array vs dictionary
9. Redim
10. Framework walk through
11. Estimations
12.Challenges faces so far
Ans: Syntax is slightly different
dim str
str="accenture"
'CASE 1:
msgbox Instr(1,str,t)
=>6
msgbox InstrRev(1,str,t)
=>6
'CASE 2:
msgbox Instr(1,str,"c")
=>2
msgbox InstrRev(1,str,"c")
=>3
#If string to be searched exists only one in provided string then index will be same.
#If more than one occurrence then Instrrev will give index of string from right to left
2. Select all names which begins with "a" in excel file with column emp name using adodb
3. Adodb fields and values
4. Regular expression question
5. FSO: from a file how many times character is repeated
6. Find how many times c appears in word "accenture"
7. Ordinal Identifiers
8. Array vs dictionary
9. Redim
10. Framework walk through
11. Estimations
12.Challenges faces so far
No comments:
Post a Comment