search
HomeCommon ProblemHow to use instr function in vb

How to use instr function in vb

Feb 27, 2020 am 10:03 AM
vbInstructions

How to use the instr function in vb

The function of the instr function is to find the first searched string starting from the starting position backwards If the position of the second occurrence is found, its position in the original string is returned, otherwise 0 is returned.

Syntax:

instr( string1, string2, start_position,nth_appearance )

Parameters:

string1: Source string, to be searched in this string.

string2: The string to be found in string1.

start_position: represents the position of string1 to start searching. This parameter is optional and defaults to 1 if omitted. String indexing starts at 1. If this parameter is positive, the search starts from left to right. If this parameter is negative, the search starts from right to left, and returns the starting index of the string to be found in the source string.

nth_appearance: Represents the number of occurrences of string 2 to be found. This parameter is optional. If omitted, the default is 1. If it is a negative number, the system will report an error.

How to use instr function in vb

Note:

The position index number starts from 1. If String2 is not found in String1, the instr function returns 0.

Example:

SELECT instr('syranmo','s') FROM dual; -- 返回 1
SELECT instr('syranmo','ra') FROM dual; -- 返回 3
SELECT instr('syran mo','at',1,2) FROM dual; -- 返回 0

PHP Chinese website, a large number of Introduction to Programming tutorials, welcome to learn.

The above is the detailed content of How to use instr function in vb. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.