{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

InStr

Returns the leftmost starting position of one string inside another.

Usage:

InStr( string1, string2 )
InStr( start, string1, string2 )
InStr( string1, string2, compare )
InStr( start, string1, string2, compare )

Parameters:

string1 The input string to check to see the position of a substring
string2 The substring to search for in x.
start The starting position to start searching in x [OPTIONAL, default is 0]
compare This decides whether to compare case-sensitive(0) or not (1) [OPTIONAL, default is 0]

Returns:

A number.

Examples:

Crystal Syntax:

inStr( "bdacbcdbc","abc" )	// Returns 0
inStr( "bcdabcbcdabc","abc" )	// Returns 4.

Basic Syntax:

formula = inStr( 5,"bcdabcbcdabc","abc" ) // Returns 10

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - InStr