Navigation: Reference > Transforms >
Extract a length of text in one or more columns.
Extract the first 2 digits from the 'Product Id' column:
•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 (0 to start with the first character). If From is End then Offset is the offset of the last character from the end (0 to start with the last character).
•Whitespace is counted when calculating length. You can use Whitespace to remove whitespace before extracting.
•If you want to set a column to a fixed length use Pad and Extract together.