- Excel Desktop Client new !
REPLACE locates the Find Text: string in the string specified in Value: and replaces that text with the text in the Replace With: parameter.
REPLACE can be useful when arbitrary input text needs to be escaped, for example when rendering characters such as < in HTML, or to allow ‘ in a database query. Regular Expressions may also be turned on for use during searching.
|Value:||Drop down list to select a string, SCALAR DORs only|
|Find Text:||The text to match in Value:, Regular Expressions allowed.|
|Replace With:||The text to replace the matched text with|
|Replacement Mode:||Select operation (ALL, FIRST)|
|Delimiter:||Character to delimit object references in Value: / Find Text: / Replace With:. default→%|
|Allow Regular Expressions:||default→FALSE, TRUE|
Examples for a REPLACE named replace1: