ReplaceField (fileDotFieldname, searchExpression, expression)

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.