Navigation: Reference > Transforms >
Remove characters from the start or end in one or more columns.
•Check the column(s) you wish to transform.
•Set Length to the number of characters you want to remove.
•Set From to Start or End depending on whether you want to remove characters from the start or end.
•Whitespace is counted when calculating length. You can use Trim to remove whitespace before chopping.
•If you want to set a column to a fixed length use Pad and Chop together.