The Remove substring operation removes a substring from a field. For example, some fields may be automatically populated when you create a table. You may wish to remove substrings from such fields if they have no analytical value.
For more information about substrings, see Operations > About substrings.
Configuring the operation
- In the Columns(s) drop-down list, select the columns where you need to remove a substring. You can also click Select all if you need to select all the columns.
- In the Substring to be removed field, specify the substring to be removed.
Important. This operation is case-sensitive (for example, Boston and boston will be treated as different substrings).
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.
Task: Some cells in the Name column were populated with "none" substrings. These substrings should be removed as they result in redundant timeline attributes.
Solution: Select the Name column and specify the substring to be removed.
Result: The table below shows the data in the original fields and the resulting data obtained by running the operation.
|John Smith||John Smith|
5/25/2023 10:12:06 AM