Replace Substring
Replaces parts of the content in a set of columns.
Examples
name |
| John Doe |
Replace Substring:
redacted
name |
| redacted |
name |
| John Doe |
Replace Substring:
redacted
On:
[A-Za-z]+$
name |
| John redacted |
name |
| John.Doe. |
Replace Substring:
,
On:
.
Once
name |
| John,Doe. |
name |
| John.Doe. |
Replace Substring:
,
On:
.
Repeatedly
name |
| John,Doe, |
Configuration
Column
Select the columns you want to edit.
To
Type the value you want to replace the matched cell content with.
On
Specifies which part of the cell content should be replaced.
The part of the cell that matches the pattern will be replaced with the value given in the To field. Choose from several predefined patterns or enter your own Regular Expression.
Note that regular expressions patterns can only be used to match against non-null cell values.
The empty string, ^$, is separate from a null value.
To match null values, use the From null update method in the Edit Text transform.
Max
Specify how many occurrences of the pattern should be replaced.
Select Once to only replace the first occurrence of the pattern, or use Repeatedly to replace all occurrences of the pattern.
Where
Add a condition to specify when the transform should be applied. If this condition is not met for a row, the value in the selected column will remain unedited.
