Replace All
This task will replace all text matched by the supplied regular expression and replace it with the supplied text.
OPTION | DESCRIPTION |
---|---|
Replacement Regular Expression | The regular expression to be used when matching text for replacement. |
Replacement Text | The text to replace all matches with. |
INPUT
No special requirements.
OUTPUT
The resulting Dex data will have all text matching the supplied regular expression replaced with the supplied replacement text. This will occur across all columns within all rows of the data.
EXAMPLE
Word Tree Data Preparation
Since a Word Tree gets confused by inconsistent whitespace and punctuation, we might use this component to prepare some text for Word Tree Analysis.
For example, suppose we run two ReplaceAll task with the following configuration:
REGEX | REPLACEMENT STRING | DESCRIPTION |
---|---|---|
[,".] | '' | Remove all commas, double quotes and periods from the text. |
\s+ | ' ' | Replace all multiple whitespace with a single space. |
Below is the before and after having run these two TrimAll task. Notice that all of the punctuation has been removed.