Extract

<< Click to Display Table of Contents >>

Navigation:  Using StreamLab > StreamLab Guides Overview > Guide Commands > Basic >

Extract

Previous pageReturn to chapter overviewNext page

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.
3.Either
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.