4D View v16PV REPLACE ONE |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D View v16
PV REPLACE ONE
|
PV REPLACE ONE ( area ; string ; replace ; where ; contains {; column ; row} ) | ||||||||
Parameter | Type | Description | ||||||
area | Longint |
![]() |
4D View area | |||||
string | String |
![]() |
String to replace | |||||
replace | String |
![]() |
Replacement string | |||||
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 row column number | |||||
![]() |
Found cell row number | |||||||
The PV REPLACE ONE command replaces character string with replace in the first cell in area that corresponds to the query criteria defined using where or contains, starting from the cell set by column and row.
string specifies the character string to search and replace with replace.
where indicates which part of the spreadsheet to query:
contains defines the type of comparison:
If the column and row optional parameters are omitted, the search begins 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 then from left to right beginning with the starting cell.
After execution of the command, the first cell found, if any, becomes the new current cell. If they were called, the column and row parameters will then contain the coordinates of this new cell.
If no cell was found during the search, the current cell remains unchanged.
Replace the first occurrence of the current VAT rate with a new reference (new rate).
C_LONGINT($Where) //0=Formula / 1=Value
C_LONGINT($Contains) //0=Contains / 1=Equals
$Where:=0 //Replacement formula
$Contains:=0 //Contains
//Replace first instance
PV REPLACE ONE(Area;"$C$30";"$C$31";$Where;$Contains)
Product: 4D View
Theme: PV Cell manipulation
Number:
15960
Created: 4D View 6.8
4D View Language ( 4D View v16)