Command PV REPLACE ALL

4D View

PV REPLACE ALL

version 6.8


PV REPLACE ALL (area; string; replace; where; contains)

ParameterTypeDescription
areaLongint4D View area
stringStringString to replace
replaceStringReplacement string
whereInteger0 = Formulas; 1 = Values
containsInteger0 = 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

PV FIND ALL, PV REPLACE ONE.