Replace (deprecated)

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Replace (deprecated)

This transform is deprecated. Use Replace instead.

 

Description

Replace text in one or more columns.

 

Examples

To turn 0123456789 into(+44) 1234 56789 using a Regular expression:

 

regex example

 

Inputs

One.

 

Options

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.

 

Notes

Comparisons are whitespace sensitive. You can use Whitespace to remove whitespace before replacing.

 

See also

Insert

Substitute