Monthly Archives: June 2010

How to get a Specific string from an array

Suppose if you want to get a specific string within an array that you don’t know on which position it is located,in this case we can go for filter condition. Filter function help you to filter a specific sub string in a string Return Value: Returns a zero-based array containing a subset of a string [...]

Get Proper/Specific Text from a String

1. To get Position of 1st occurence of the string within the string mvar=Instr(“VB Script is fun!”,”is”) msgbox(mvar)’returns 1st occurence position of the string/letter within another string 2.To get specific length of the string MyVar = Mid(“VB Script is fun!”, mvar, 2) msgbox(MyVar)  ‘ Returns ” is” 3.Suppose if you want to get specific text [...]

Follow

Get every new post delivered to your Inbox.