Stories
Live tasks
Bricks
Login
Back to bricks list
Introduction Version

Table replace

TRANSFORMER
Typing name :  TASK.gws_core.TableReplace Brick :  gws_core

Replace values in a table with other values

You can provided multiple values to replace. It also supports regex. If multiple values are provided, there are replaced sequentially, so the second replace can rewrite the first replace. The table's tags are kept.

For each configuration, if Is regex is checked, the search value is considerer as a regex and there is no modification to it. Otherwise the search value is converted (see Convertion). The replace value is always converted.

Convertion

The params values supports 2 special values:

  • NaN: convert to NaN
  • None: convert to None

If the value is someting else, the system tries to convert it to a number. If this is convertible to a number the system will use the number, otherwise the value is kept as is.

Input

Table
2d excel like table
Table

Output

Table
2d excel like table
Table

Configuration

replace_values

Type : ListMaximum occurrences number : -1

search_value

Optional

Value to search for. Use 'NaN' for NaN and 'None' for None

Type : string

replace_value

Optional

Use 'NaN' for NaN and 'None' for None

Type : string

is_regex

Optional

If true, the search value is interpreted as a regex

Type : bool