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 Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use