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.