Instr/InstrRev - Revision history

Ghenne: /* Output */

2019-03-25T15:27:17Z

Output

← Older revision		Revision as of 15:27, 25 March 2019
Line 45:		Line 45:

	[[Category:Strings]]		[[Category:Strings]]

			[[Category:BASIC Functions]]

Ghenne at 17:47, 24 March 2019

2019-03-24T17:47:37Z

@@ Line 1: / Line 1: @@
 Instr([''start'', ]''string1'', ''string2''[, ''compare''])
@@ Line 31: / Line 33: @@
 Print "Finding ""man"" from start:", Pos1
 Print "Finding ""big"" from end:", Pos2
 </pre>

Ghenne at 21:20, 14 April 2014

2014-04-14T21:20:56Z

← Older revision		Revision as of 21:20, 14 April 2014
Line 9:		Line 9:
	InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.		InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.

	The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise 0 is returned if ''string2'' is not found in ''string1''.		The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 1 being the location of the first character, otherwise 0 is returned if ''string2'' is not found in ''string1''.

	'''Table: Comparison constants'''		'''Table: Comparison constants'''

JwellsNB: Add javascript snippet

2013-05-27T19:18:21Z

Add javascript snippet

@@ Line 22: / Line 22: @@
 |}
-== Example ==
+== Example (Basic) ==
 <pre>
@@ Line 31: / Line 31: @@
 Print "Finding ""man"" from start:", Pos1
 Print "Finding ""big"" from end:", Pos2
 </pre>

Ghenne: /* Description */

2013-02-12T18:36:37Z

Description

← Older revision		Revision as of 18:36, 12 February 2013
Line 9:		Line 9:
	InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.		InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.

	The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise -1 is returned if ''string2'' is not found in ''string1''.		The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise 0 is returned if ''string2'' is not found in ''string1''.

	'''Table: Comparison constants'''		'''Table: Comparison constants'''

Ghenne: Ghenne moved page Instr/instrrev to Instr/InstrRev

2012-11-06T11:46:00Z

Ghenne moved page Instr/instrrev to Instr/InstrRev

← Older revision		Revision as of 11:46, 6 November 2012
(No difference)

Ghenne: /* Description */

2012-10-09T11:49:19Z

Description

← Older revision		Revision as of 11:49, 9 October 2012
Line 10:		Line 10:

	The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise -1 is returned if ''string2'' is not found in ''string1''.		The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise -1 is returned if ''string2'' is not found in ''string1''.

			'''Table: Comparison constants'''

			{\| class="wikitable"
			\|-
			! Constant !! Value !! Description
			\|-
			\| vbBinaryCompare \|\| 0 \|\| Binary comparison case sensitive (default)
			\|-
			\| vbTextCompare \|\| 1 \|\| Textual comparison, case insensitive
			\|}

	== Example ==		== Example ==

Ghenne: /* Output */

2012-10-09T10:58:42Z

Output

← Older revision		Revision as of 10:58, 9 October 2012
Line 26:		Line 26:
	<pre>		<pre>
	Finding "man" from start: 5		Finding "man" from start: 5
	Finding "big" ~~form~~ end: 1		Finding "big" from end: 1
	</pre>		</pre>

Ghenne: /* Description */

2012-10-09T10:58:11Z

Description

← Older revision		Revision as of 10:58, 9 October 2012
Line 9:		Line 9:
	InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.		InstrRev returns a long value specifying the position of one string within another, measured from the end of the string searched.

	The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If "start" is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If "string2" is found in "string1", a positive integer is returned with 0 being the location of the first character, otherwise -1 is returned if "string2" is not found in "string1".		The optional parameter, ''start'', is a numeric expression that specifies the starting position of the search within the target string. If ''start'' is not provided, the search defaults to 1, the first character position for Instr, or -1, the last character position for InstrRev. The required parameter, ''string1'', is the string being searched. The required parameter, ''string2'', is the string that is being searched for. The optional parameter, ''compare'', is used to specify the type of search performed. If ''string2'' is found in ''string1'', a positive integer is returned with 0 being the location of the first character, otherwise -1 is returned if ''string2'' is not found in ''string1''.

	== Example ==		== Example ==

Ghenne: /* Example */

2012-10-09T10:55:11Z

Example

← Older revision		Revision as of 10:55, 9 October 2012
Line 17:		Line 17:
	Dim Pos1, Pos2		Dim Pos1, Pos2
	Pos1 = Instr("Cartman", "man")		Pos1 = Instr("Cartman", "man")
	Pos2 = InstrRev("Big Al's Big Boat Ride", _		Pos2 = InstrRev("Big Al's Big Boat Ride", "big", 4, vbTextCompare)
	"big", 4, vbTextCompare)
	Print "Finding ""man"" from start:", Pos1		Print "Finding ""man"" from start:", Pos1
	Print "Finding ""big"" from end:", Pos2		Print "Finding ""big"" from end:", Pos2