Home / Guides / Replacement

Replacement · Rowlane guide

Make find-and-replace changes reviewable

A literal search is safer to reason about than a broad text rule, but every replacement still deserves a before-and-after check.

Use a narrow field and phrase

Choose one column where the target text has a consistent meaning. For example, replacing Lane inside a name may be right for a controlled address suffix but wrong if it occurs inside an unrelated word.

Choose whole-cell or substring matching

Whole-cell mode changes only cells equal to the search text. Substring mode replaces every occurrence. Case-insensitive matching ignores letter case but does not remove whitespace or normalize Unicode punctuation.

Re-run from the unchanged source

The result preview is generated from the input text, not by editing that source. If a replacement is too broad, change the rule and run again against the same input. The changed-cell count is not a substitute for reviewing high-impact records.

Try this workflow: Find and replace. It loads a labelled fictional example that you can edit.