The Replace substring operation replaces a substring or an empty string with a value of your choice. You can use this operation to quickly fix a typo in an employee's name, for example.
For more information about substrings, see Operations > About substrings.
Configuring the operation
- In the Columns(s) drop-down list, select the columns that you need to modify. You can also click Select all if you need to select all the columns.
- In the Substring to be replaced field, specify the substring to be replaced with another.
Important! This operation is case-sensitive (for example, Boston and boston will be treated as different substrings).
- Select Replace only empty values, if you want a new substring to be placed into empty fields.
- In the New substring field, specify a new substring that will replace the substring you specified in step 2.
If required, you can use a filter and preview the results of the operation
You can use a filter to run the operation only on data that meets certain criteria.
For details, see Using Filters with Operation.
To preview the results that you can obtain with the operation, click Run preview. The program will show you how the first 100 rows in your table will look like after the operation is executed. Please note that it may take some time to generate a preview.
- Click Save. The Edit Operation window will close and the new operation will appear in the Operations pane.
Replacing a substring
Task: In the Location column, replace Boston with Springfield, as invoice processing has been moved to the branch office in that city.
Solution: Select the columns that contain the substring to be replaced. Then specify the actual substring to be replaced: Boston. Finally, specify Springfield as the new substring.
Result: The table below shows the data in the original fields and the resulting data obtained by running the operation.
|Boston, branch office||Springfield, branch office|