Truncate

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Truncate

Description

Truncate text to a maximum length in 1 or more columns.

 

Inputs

1.

 

Options

Check the column(s) you wish to transform.

Set Maximum length to the length you want values in selected columns truncate to. Values this length or shorter are unaffected.

Set Truncate to Left or Right depending on where you want any excess characters removed.

 

Notes

Whitespace is counted when calculating length. You can use Trim to remove whitespace before padding.

If you want to set a column to a fixed length use Pad and Truncate together.