4D Doc Center : PV REPLACE ALL

Home

4D View v14

PV REPLACE ALL


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)