Comment on page
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.