Extract

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Extract

Description

Extract a length of text in one or more columns.

 

Inputs

One.

 

Options

Check the column(s) you wish to transform.

Set Length to the length you want values in selected columns shortened to.

Set From to Start or End depending on whether you want to take from the start or end.

If From is Start then Offset is the offset of the first character from the start. If From is End then Offset is the offset of the last character from the end.

 

Notes

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

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

 

See also

Chop