Insert

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Insert

Description

Append/prepend text to one or more columns.

 

Example

Add 'ID-' to the front of a column of text:

 

how to append text to a column example

 

Inputs

One.

 

Options

Check the column(s) you wish to transform.

In Insert put the text you want to insert. You can use a column variable.

In At put the position you want the text inserted.

 

Notes

You can use Whitespace to remove whitespace before inserting.

 

See also

Pad

Extract