.. _`Replace values in Table`:

.. _`org.sysess.sympathy.data.table.tablevaluesearchreplace`:

Replace values in Table
~~~~~~~~~~~~~~~~~~~~~~~

.. image:: search_replace.svg
   :width: 48


Search and replace string and unicode values in Table.

*Input ports*:
    :table: table

        Input Table

*Output ports*:
    :table: table

        Table with replaced values

*Configuration*:
    **Select columns** (columns)
        Select the columns to use perform replace on
    **Search** (find)
        Specify search expression.
    **Replace** (replace)
        Specify replace expression.
    **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.
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Use default** (use_default)
        Use default value when not found.
    **Default value** (default)
        Specify default value

.. automodule:: node_table_value_search_replace

.. class:: TableValueSearchReplace


Example flows
#############

* :download:`ReplaceValuesInTable.syx </_examples/Sympathy/Data Processing/Data/ReplaceValuesInTable.syx>`