IT. Expert System.

VBS

InStr()


Description

The InStr() function returns the position of the first occurrence of one string within another.

The InStr() function can return the following values:

  • If string1 is "" - InStr returns 0
  • If string1 is Null - InStr returns Null
  • If string2 is "" - InStr returns start
  • If string2 is Null - InStr returns Null
  • If string2 is not found - InStr returns 0
  • If string2 is found within string1 - InStr returns the position at which match is found
  • If start > Len(string1) - InStr returns 0

Tip: Also look at the InStrRev function

This function has the form:

InStr([start,] string1, string2 [,compare])
Parameter Description
start (optional) Specifies the starting position For Each search. The search begins at the first character position (1) by default. This parameter is required if compare is specified
string1 (required) The string to be searched
string2 (required) The string expression to search for
compare (optional) Specifies the string comparison to use (default = 0). Can have one of the following values:
  • 0 = vbBinaryCompare - Perform a binary comparison
  • 1 = vbTextCompare - Perform a textual comparison

Examples

The following examples show the basic use of this function:

Example 1

txt="This is a beautiful day!"
Msgbox(InStr(txt, "beautiful"))

This produces the following result:

11

Example 2

Finding the letter "i", using different starting positions:

txt="This is a beautiful day!"
Msgbox(InStr(1,txt,"i"))
Msgbox(InStr(7,txt,"i"))

This produces the following result (each line in a separate pop-up message box):

3
16

Example 3

Finding the letter "t", with textual, and binary, comparison:

txt="This is a beautiful day!"
Msgbox(InStr(1,txt, "t",1))
Msgbox(InStr(1,txt, "t",0))

This produces the following result (each line in a separate pop-up message box):

1
15

Miscellaneous Information

Supported in Version: 1.0


Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 168 / 158781207. Delta: 0.02474 с