Srch - Revision history

Mikhail.zheleznov: Added the fact that -1 is returned if not found. And that ^ makes it search for sub-strings

2015-12-28T00:10:59Z

Added the fact that -1 is returned if not found. And that ^ makes it search for sub-strings

← Older revision		Revision as of 00:10, 28 December 2015
Line 1:		Line 1:

	The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.		The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. If the argument is not found, then either 0 (BR 4.1 and below) or -1 (BR 4.2 and above). The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

	SRCH(<array-name>,<argument>[,<row>])		SRCH(<array-name>,<argument>[,<row>])
Line 10:		Line 10:
	====Optional Case Insensitivity and Substring matching====		====Optional Case Insensitivity and Substring matching====

	If argument$ begins with the caret ^, then the ^ is stripped and the search for argument$ in array-name$ becomes '''case insensitive''' (as of 4.2).		If argument$ begins with the caret ^, then the ^ is stripped and the search for argument$ in array-name$ becomes '''case insensitive''' (as of 4.2). Also, when the caret ^ is specified, the search is performed for sub-strings instead of whole strings.

	For example:		For example:

Laura: /* Comments and Examples */

2014-09-23T15:16:22Z

Comments and Examples

← Older revision		Revision as of 15:16, 23 September 2014
Line 31:		Line 31:
	is in effect or OPTION 56 is in effect.		is in effect or OPTION 56 is in effect.

	For versions 4.1 and earlier, when the search is unsuccessful, Srch returns -1 ~~(unless~~ [[~~option (config)\|option~~]] ~~56 is enabled, in which case srch would~~ return a 0). In line 510 below, if STATES$ is a string array containing the 50 valid two-letter state abbreviations, then a data entry program could check whether the operator entered a correct abbreviation into the variable ST$ by the following:		For versions 4.1 and earlier, when the search is unsuccessful, Srch returns -1. Using OPTION [[BASE]] 0 will also cause SRCH to return a zero.

			In line 510 below, if STATES$ is a string array containing the 50 valid two-letter state abbreviations, then a data entry program could check whether the operator entered a correct abbreviation into the variable ST$ by the following:

	500 LINPUT ST$		500 LINPUT ST$
	510 If Srch(Mat States$,ST$) = -1 then goto 500		510 If Srch(Mat States$,ST$) = 0 then goto 500

	The example below will find the selected item in a [[combo box]]		The example below will find the selected item in a [[combo box]]

Laura: /* Optional Case Insensitivity and Substring matching */

2014-09-22T19:48:32Z

Optional Case Insensitivity and Substring matching

← Older revision		Revision as of 19:48, 22 September 2014
Line 21:		Line 21:

	1		1

			Given the (4.2+) SRCH use of the "^" character, to search for '^' with
			"let X=POS(string$,'^',5)" you will need to either turn the search character
			off with CONFIG SEARCH_CHAR OFF or replace the search character with something else as in CONFIG SEARCH_CHAR 7E (where 7E is the hexadecimal representation of an alternate search character).

	====Comments and Examples====		====Comments and Examples====

Laura: /* Comments and Examples */

2014-09-22T19:47:23Z

Comments and Examples

← Older revision		Revision as of 19:47, 22 September 2014
Line 24:		Line 24:
	====Comments and Examples====		====Comments and Examples====

	~~When~~ the search is unsuccessful, Srch returns -1 (unless [[option (config)\|option]] 56 is enabled, in which case srch would return a 0). In line 510 below, if STATES$ is a string array containing the 50 valid two-letter state abbreviations, then a data entry program could check whether the operator entered a correct abbreviation into the variable ST$ by the following:		As of 4.2, SRCH returns zero if it fails (instead of -1) unless OPTION BASE ZERO
			is in effect or OPTION 56 is in effect.

			For versions 4.1 and earlier, when the search is unsuccessful, Srch returns -1 (unless [[option (config)\|option]] 56 is enabled, in which case srch would return a 0). In line 510 below, if STATES$ is a string array containing the 50 valid two-letter state abbreviations, then a data entry program could check whether the operator entered a correct abbreviation into the variable ST$ by the following:

	500 LINPUT ST$		500 LINPUT ST$

Laura: /* Optional Case Insensitivity and Substring matching */

2014-09-22T19:38:48Z

Optional Case Insensitivity and Substring matching

← Older revision		Revision as of 19:38, 22 September 2014
Line 10:		Line 10:
	====Optional Case Insensitivity and Substring matching====		====Optional Case Insensitivity and Substring matching====

	If argument$ begins with the caret ^, then the ^ is stripped and the search for argument$ in array-name$ becomes '''case insensitive'''.		If argument$ begins with the caret ^, then the ^ is stripped and the search for argument$ in array-name$ becomes '''case insensitive''' (as of 4.2).

	For example:		For example:

Laura at 03:11, 22 May 2014

2014-05-22T03:11:19Z

← Older revision		Revision as of 03:11, 22 May 2014
Line 2:		Line 2:
	The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.		The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

			SRCH(<array-name>,<argument>[,<row>])
	~~Srch~~(array-name,argument[,row])

	OR		OR

	~~Srch~~(array-name$,[^]argument$[,row])		SRCH(<array-name$>,[^]<argument$>[,<row>])

	====Optional Case Insensitivity and Substring matching====		====Optional Case Insensitivity and Substring matching====

John at 14:50, 3 April 2014

2014-04-03T14:50:45Z

← Older revision		Revision as of 14:50, 3 April 2014
Line 1:		Line 1:

	The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.		The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

	~~====Syntax====~~

John at 14:46, 3 April 2014

2014-04-03T14:46:28Z

← Older revision		Revision as of 14:46, 3 April 2014
Line 2:		Line 2:
	The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.		The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

	===Syntax===		====Syntax====

John at 14:46, 3 April 2014

2014-04-03T14:46:01Z

← Older revision		Revision as of 14:46, 3 April 2014
Line 1:		Line 1:

			The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

			===Syntax===


	Srch(array-name,argument[,row])		Srch(array-name,argument[,row])

Line 4:		Line 10:

	Srch(array-name$,[^]argument$[,row])		Srch(array-name$,[^]argument$[,row])

	The '''Srch''' [[internal function]] searches an [[arrays\|array]] and returns the row number matching the argument. The argument must be the same data type (string or numeric) as the array. The optional "row" parameter defines the starting array element for the search.

	====Optional Case Insensitivity and Substring matching====		====Optional Case Insensitivity and Substring matching====

John: moved SRCH to Srch over redirect

2014-01-31T14:56:33Z

moved SRCH to Srch over redirect

← Older revision	Revision as of 14:56, 31 January 2014
(No difference)