Replace values in Tables

In the standard library there exist three nodes which perform a search and replace of values among the elements in Tables. Of the three nodes, one operates on single Table while the second operates on multiple Tables. The third one operates on a single table but can also take a table with expressions as input.

In the configuration of the nodes one has to specify the columns in the Tables which will be regarded during the execution of the node. At the moment the node is restricted to string and unicode columns.

For string and unicode columns the search and replace expressions may be regular expressions. Here, it is possible to use ()-grouping in the search expression to reuse the match of the expression within the parentheses in the replacement expression. In the regular expression for the replacement use \\1 (or higher numbers) to insert matches.

As an example let’s say that you have an input table with a column containing the strings x, y, and z. If you enter the search expression (.*) and the replacement expression \\1_new the output will be the strings x_new, y_new, and z_new.

For the expression table it should look like this:

Find column          | Replacement column
---------------------------------------------------
Expression to find 1 | Replacement for expression 1
Expression to find 2 | Replacement for expression 2
         ...         |             ...

class node_table_value_search_replace.TableValueSearchReplaceMultiple

Search and replace string and unicode values in Tables.

Inputs:

tables : [table]

Input Tables

Outputs:

tables : [table]

Tables with replaced values

Configuration:

Select columns

Select the columns to use perform replacement on

Search expression

Specify search expression.

Replacement expression

Specify replace expression.

Use default

Use default value when not found.

Default value

Specify default value