Navigation: Reference > Transforms >
Remove characters from the start or end in one or more columns.
Remove leading zeros:
•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 Whitespace to remove whitespace before chopping.
•If you want to set a column to a fixed length use Pad and Chop together.