Skip to main content

Varicent ELT Help Center

Trim tags

Abstract

Trim tags from HTML.

Use the Trim Tags tool to trim tags from HTML. If you have a text column written in HTML, you can use the Trim Tags tool to remove tags from the values.

Input

The Trim Tags tool requires one data input.

Configuration

Use the following configuration options to configure the Trim Tags tool.

Configuring the Trim Tags 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 Trim Tags and then click + Add Tool.

    Tip

    You can also find the Trim Tags tool in the Clean 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. Trim Tags tool configuration

    Field

    Description

    Column

    Select the text column to trim HTML tags from.

    New column name

    Enter a new column name, or use the populated one which has _Trimmed appended.