Command PV FIND ONE

PV FIND ONE

version 6.8

PV FIND ONE (area; criteria; where; contains{; column; row })

Parameter	Type		Description
area	Longint		4D View area
criteria	String		String to query
where	Integer		0 = Formulas; 1 = Values
contains	Integer		0 = Contains; 1 = Equals
column	Longint		Starting cell column number
			Found cell column number
row	Longint		Starting cell row number
			Found cell row number

The PV FIND ONE command searches for criteria among the cells of the area. The search will stop at the first cell, if any, that meets the search criteria.

criteria specifies the character string to query.

where indicates which part of the spreadsheet to query:

• 0: Queries formulas

• 1: Queries values

contains defines the type of comparison:

• 0: Partial (contains the queried value)

• 1: Total (equal to the queried value)

If the column and row optional parameters are omitted, the search starts at the top left corner of the area.

If column and row are passed, they indicate the cell of the area from which the search will begin.

The search is carried out from top to bottom and left to right, beginning with the indicated cell.

After executing the command, the first cell eventually found becomes the new current cell. If they were called, the column and row parameters then contain coordinates.

If no cell was found during the search, the current cell remains unchanged.

Let's query the first cell containing the user response to an initial request. The query will start in the cell B3.

   C_STRING(255;$Criteria)  `String to query
   C_INTEGER($QueryWhere)  `0=Formulas / 1=Values
   C_INTEGER($Contains)  `0=Equals / 1=Contains
   C_LONGINT($Column)  `Column number of found cell
   C_LONGINT($Row)  `Row number of found cell

   $Criteria:=Request("What value should be queried?";"x")

   If ($Criteria#"")  `Defined criteria
      CONFIRM("Query formulas or values?";"Values";"Formulas")
      $QueryWhere:=OK  `0=Formulas / 1=Values

      CONFIRM("What kind of comparison?";"Contains";"=")
      $Contains:=OK    `0=Contains / 1=Equals

       $Column:=2  `Search starting from cell B3
      $Row:=3 

      PV FIND ONE (Area;$Criteria;$QueryWhere;$Contains;$Column;$Row)  `Query
   End if  

PV FIND ALL, PV REPLACE ONE.