Replace

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Replace

Description

Replace text in one or more columns.

 

Inputs

One.

 

Options

Check the column(s) you wish to transform.

Choose whether to use text or Regular expression matching.

In Replace put the text you want to replace.

In With put the text you want to replace it with.

 

Notes

Comparisons are case and whitespace sensitive. You can use Case to change the case and Trim to remove whitespace before replacing.

 

Example

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

 

regex

See also

Insert

Substitute