Table Search and Replace

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

In the standard library there exist four nodes which perform a search and replace of values among the elements in Tables. Of the four nodes, one operates on single Table while the second operates on multiple Tables. The third and fourth are the same but instead of a GUI configuration, they take another table as configuration. See below.

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. The node works with string, unicode, integer, and float values.

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 (for the ‘with Table’ versions) it should it have the following structure:: +————————+——————————+ | 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.TableSearchReplaceFromTable(*args, **kwargs)[source]
Inputs:
expressions : table

Expressions

data : table

Table Data

Outputs:
data : table

Table with replaced values

Configuration:
Column to replace values in

Select in which to perform replacement

Column with search expressions

Select which column contains search expressions

Column with replace expressions

Select which column contains replacements

Enable regular expressions

Enable regular expressions in the search and replace expressions

Ignore case

Ignore case when searching