Skip to main content

Varicent ELT Help Center

Text part

Abstract

Select the beginning, middle, or end of the text in the specified column.

Select the beginning, middle, or end of text in the specified column.

With the Output column(s) option, you can also add new columns or replace existing selected columns in your data set. The columns append to your data set, with the naming convention of (column)_extracted, for example: Monthly Sales_extracted. This option is available in both the standard pipe and the big pipe.

Input and output

To use this tool, you need a text column.

When you run this tool, it replaces the data in the text column with the part you specify.

When to use this tool

Use when you want to extract part of a text column.