The Extract command lets you pull content from a column, such as the first four characters, to create a new column. As new data streams in, this new column will be updated. (Data from the first column is not deleted.)
To do so:
1.Enter a name for the new column.
2.Select a column from the drop-down menu.
oSelect the part of the cell's string that you'd like to extract.
oEnter a starting point in the Start field and a string length in the Length field.
4.From the drop-down menu, select an option for handling strings that are too small. You can choose to truncate, use an empty string, or use NULL.
5.Click the + icon to add the command to the Guide script.
6.The results of the script appear in the Output View window.