Replace values in a column with other values

Find/Replace searches a table for provided string and replaces it with another string. Multiple find/replace rules may be applied in a single tool, and they may be applied to an entire table or specified columns.

Three options exist for how to identify strings within the given table:

  • Find by string: enter strings to find/replace. Option to allow matches with entire cells or partial matches within cells.

  • Find by regex: use regular expressions to match cell segements. Replace with the provided string.

  • Find by delimiter: Enter starting and ending delimiters, any strings between the provided delimiters will be replaced.

To find/replace null values, select "Find by String" and simply type "null" into the find box.

Last updated