> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/tools/cleaning/findreplace.md).

# Find/Replace

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.