Result Type: Number
Definition: Analogous to the Advanced Replace command, this replaces the specified field in the records identified by the searchExpression by the expression.
ReplaceField("product.sellPrice", "category1=`BRONZE`", "sellPrice*1.20")
increases the sell price for all products whose category1 is "BRONZE" by 20%. The return value is the number of products that were changed.
ReplaceField("transaction.colour", "gross>10000", "`red`")
Sets the colour of all transactions with a gross more than $10,000 to red. The number of transactions that were changed is returned.
Note: As this function changes data (and there is no undo), it should be used with extreme caution.