Extracts n number of characters from the beginning of a string.
You can either:
right-click on a Text field
click the drop down of a Text field
then select Substring... in the context menu that displays.
The Substring dialog displays.
Enter the value or click in Start Position to define the where the extraction will start.
Enter the value or click in Length to define the length of the extraction.
Enter the value or click in Sample Row to select the row number that a sample of the substring definition that will be displayed in the Result Column box below:
Check the Remove Original Column box to delete the original column and just display the new substring instead.
Click OK. The new substring values are displayed.