# Replace Text

<figure><img src="/files/8u6ZWnn52dV5jrA9PVC2" alt=""><figcaption></figcaption></figure>

## Overview

The Find and Replace Node allows you to search for specific text within one or multiple columns in your dataset and replace the found text with a specified value. In this guide, we will explain the properties and functionalities of the Find and Replace Node.

<figure><img src="/files/1TQmmNJz1ediSRS6aUeW" alt=""><figcaption></figcaption></figure>

## **Settings**

#### **Search into**

In the "Search Into" property, select one or multiple columns to search for the specified text or pattern. The selected columns should contain text data that can be processed using the specified text or pattern.

#### **Find**

Specify the text or regex pattern to find using the "Find" property. You can choose between a text string or a regular expression (regex) pattern:

1. Text string: Enter a simple text string that will be used to find the text within the column values.
2. Regex pattern: Enter a regular expression pattern that will be used to find the text within the column values. Find out how to use Regex [Using Regex](/tutorials/using-regex.md) and the list of supported tokens [Regex: List of Tokes](/data-transformation/formulas/regex-list-of-tokes.md)

#### **Replace with**

Enter the replacement text in the "Replace With" property. This text will replace the found text or pattern within the selected columns.

#### **Ignore case**

Enable the "Ignore Case" toggle if you want the search process to be case-insensitive. When this option is enabled, the Find and Replace Node will not differentiate between uppercase and lowercase characters when finding the text.

#### **Match all occurrences**

The "Match All Occurrences" toggle is enabled by default. When this option is enabled, the Find and Replace Node will search for and replace all occurrences of the specified text or pattern within the selected columns.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tabula.io/data-flows/tools-nodes/columns-operations/replace-text.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.