Text/Clean

Find and replace

Replaces text found by plain search or regex with something else.

Example

  • Options used
  • Find(\d{4})-(\d{2})-(\d{2})
  • Replace with$3/$2/$1
  • Regex✓
Input
2026-09-23
2025-12-01
Output
23/09/2026
01/12/2025

Symbols in examples: ⇥ tab · · trailing space · ⍽ NBSP · □ full-width space · ◌ zero-width character

Open this operation in the tool

What it does

Replaces every occurrence of the search text with the replacement. You can add it to a pipeline several times to apply multiple rules in sequence.

Plain mode

Searches for exactly the characters you type. Symbols like . * ( have no special meaning and match themselves. With 'Interpret \n \t as line break and tab' turned on, \n becomes a line break and \t a tab in both the search and replacement text. This is handy for turning tabs into commas or inserting a line break after a certain symbol. A $ in the replacement is inserted literally.

Regex mode

Searches using JavaScript regular expression syntax. The global (g), multiline (m) and Unicode (u) flags are applied, so ^ and $ match the start and end of each line. In the replacement, $1, $2 refer to capture groups and $& to the whole match.

  • Change a date format: (\d{4})-(\d{2})-(\d{2}) → $3/$2/$1
  • Remove trailing spaces: [ \t]+$ → (empty)
  • Remove parentheses and their contents: \s*\([^)]*\) → (empty)
  • Mask the middle of a phone number: (\d{3})-\d{3,4}-(\d{4}) → $1-****-$2

Errors

If the regex is invalid, for example because of unbalanced parentheses, the step shows an error and passes its input on to the next step unchanged. See the regex guide for more patterns. To delete whole lines, Filter lines is simpler.