- Excel Desktop Client new !
REPEATED REPLACE locates one string in another and then replaces the text with new text.
Any LIST references in the input string of length greater than one must all have the same length.
The replace operation is repeated for each value in the input LIST. The output LIST will be the same length as the input LIST(s).
REPLACE is helpful 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 be active for a search.
For specific examples, see REPLACE.
|Value:||Dropdown list to select a string, String DORs only.|
|Find Text:||The text to search for|
|Replace With:||The text to replace the found text with|
|Replacement Mode:||Select operation (ALL, FIRST)|
|Delimiter:||Character to act as delimiter for object reference in Value:, Find Text: and Replace With:. default→%|
|Allow Regular Expressions:||default→FALSE|