Replace values in Table with Table¶
Search and replace values in specified columns table with search expressions from a table
Documentation¶
Replacements will be performed in all selected columns.
Regex¶
If Text replace only (using regex) is checked, the search expression may be a regular expression (regex). For more information about how to write regex, see Regular expression syntax. Here, it is possible to capture part of the match using parentheses in the search expression, see Grouping and capturing.
Unless configured to use regex replacement, search, replace and default values will be read as a values of the same type as the column it is replacing in. For details about how to enter values for different types, see Input typed values as text.
Definition¶
Input ports¶
- expressions table
Expressions
- data table
Table Data
Output ports¶
- data table
Table with replaced values
Configuration¶
- Columns to replace values in (column)
Select in which to perform replace
- Column with search expressions (find)
Select which column contains search expressions
- 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. Learn more about Regular expression syntax in the documentation appendix.
- Column with replace expressions (replace)
Select which column contains replacements
Examples¶
Implementation¶
- class node_table_value_search_replace.TableValueSearchReplaceWithTable[source]