<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Replace (deprecated) |
This transform is deprecated. Use Replace instead.
Replace text in one or more columns.
To turn 0123456789 into(+44) 1234 56789 using a Regular expression:
One.
•Check the column(s) you wish to transform.
•Choose the Match type as:
oText to replace matches contained in the text.
oExact text to replace the text only if it matches exactly (whitespace sensitive).
oRegex to match using a Regular expression.
oEmpty to match empty cells (cells with whitespace are not empty).
•In Replace put the text you want to replace for Text, Exact text or Regex matching. You can use a column variable.
•In With put the text you want to replace it with. You can use a column variable.
•Check case sensitive to use case sensitive matching for Text, Exact text or Regex matching.
•Comparisons are whitespace sensitive. You can use Whitespace to remove whitespace before replacing.