Skip to main content

Varicent ELT Help Center

Text part

Abstract

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

Use the Text Part tool to extract part of a text column. Select the beginning, middle, or end of the 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

The Text Part tool requires one data set with text columns.

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

Configuration

Use the following configuration options to configure the Text Part tool.

Configuring the Text Part tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.

  5. In the Tools modal, search for Text Part and then click + Add Tool.

    Tip

    You can also find the Text Part tool in the Calculate section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, enter the following information:

    Table 63. Text Part tool configuration

    Field

    Description

    Left - Mid - Right

    Click the direction button where to extract from.

    • Left extracts text from the left side.

    • Mid extracts text from the middle of the text.

    • Right extracts text from the right side.

    Columns

    Select the columns to extract the text from.

    Length

    Enter the length of the text extraction or use the arrows to increase or decrease the number.

    Start

    Enter where to start the extraction when using the Mid button.

    Advanced

    Output column(s)

    Choose between either Add new column(s) or Replaces selected column(s) to add or replace columns in your data set.