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.
•If you can to keep the original column use Copy Cols to copy the column first.
•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.