PV REPLACE ALL
version 6.8
PV REPLACE ALL (area; string; replace; where; contains)
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 |
Description
The PV REPLACE ALL command is similar to the PV REPLACE ONE command, except that it replaces the character string with the string replace in all area cells found corresponding to the query criteria defined with the where or contains parameters.
After calling this command, the first cell eventually found becomes the new current cell and the other cells found are selected.
If no replace has occurred, the active cell remains unchanged.
Example
Make all occurrences of the "Amount" string appear in capital letters:
PV REPLACE ALL (Area;"Amount";"AMOUNT";1;1)
See Also