Replace values in Tables

../../../../_images/search_replace.svg

Search and replace values in Table.

Documentation

Auto generated list version of Replace values in Table.

In this version, the following ports from the original nodes have been changed to lists which the node loops over:

Looped Inputs

table.

Looped Outputs

table.

For details see the original node.

Definition

Input ports

tables [table]

Input Table

Output ports

tables [table]

Table with replaced values

Configuration

Select columns (columns)

Select the columns to use perform replace on

Default value (default)

Specify default value

Search (find)

Specify search expression.

Ignore case (ignore_case)

Ignore case when searching

Text replace only (using regex) (literal)

Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns.

Replace (replace)

Specify replace expression.

Use default (use_default)

Use default value when not found.

Implementation

class node_table_value_search_replace.TableValueSearchReplaceMultiple[source]