Find and Replace
Replaces a sequence of characters in a string variable with another sequence of characters. |
For example, you might replace the spaces in a string with commas.
Set the variable to search
Enter the string variable in which to replace one or more occurrences of a character sequence.
Set the variable/value to find
Enter the string's character sequence to replace (a literal value preceded by =, or a string variable).
Set the variable / value to replace with
Enter the sequence of characters to replace with (a literal value preceded by =, or a string variable).
Set the variable to hold the result
The string variable in which to store the result. The variable in Set the variable to search can be used here in which case it will be overwritten by this result.
Use wildcards (?,*) in find string
Select this to include the wildcards ? and/or * in your search.
A ? matches any single character. For example, the following configuration finds all account numbers starting with any first digit and ending in 0124 (00124, 10124, 20124 and so on) and replaces each of them with X0124.
A * matches any character sequence. For example, the following configuration finds all account numbers starting with 'Account', a character sequence, and '00' (Account JB 00, Account FGR 00, Account AIK01 00, and so on), and replaces each of them with 'Account Reference 00'.
Case Sensitive
Select this option to find and replace text that matches the case in Set the variable/value to find.
Select which items should be replaced
For a character sequence that has been found, select which occurrences to replace (all, first, last, or nth).
Exit point |
Taken |
[Complete] |
When cell execution completes. |