# Replace text

The replace text step allows to replace in a text column a substring by another substring.

### Step parameters

* `Extract a substring from ...` column(string)\*: the column in which to search for the value to to replace
* `Old string` **(string)\***: value to search for in the previously defined column
* `New string` **(string)**\*: value with which the old string will be replaced

### Example

**Input**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-b05f6cbc7868b8c6f0dd161cbbcc378b2f46121f%2Finput_text.png?alt=media" alt=""><figcaption><p>Text - Replace Text input</p></figcaption></figure>

**Configuration**

```json
{
    "search_column": "",
    "old_str": "example",
    "new_str": "acme"
}
```

**Output**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-f0f778d7899d94e172311c006123853bfd55460e%2Freplace_text.png?alt=media" alt=""><figcaption><p>Text - Replace Text output</p></figcaption></figure>
