> For the complete documentation index, see [llms.txt](https://docs.selfuel.digital/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.selfuel.digital/data-integration-with-nexus/nexus-elements/transform/replace.md).
# Replace
> Replace transform plugin
### Description[](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#description)
Examines string value in a given field and replaces substring of the string value that matches the given string literal or regexes with the given replacement.
### Options[](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#options)
| name | type | required | default value |
| -------------- | ------- | -------- | ------------- |
| replace\_field | string | yes | |
| pattern | string | yes | - |
| replacement | string | yes | - |
| is\_regex | boolean | no | false |
| replace\_first | boolean | no | false |
#### replace\_field \[string][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#replace_field-string)
The field you want to replace
#### pattern \[string][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#pattern-string)
The old string that will be replaced
#### replacement \[string][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#replacement-string)
The new string for replace
#### is\_regex \[boolean][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#is_regex-boolean)
Use regex for string match
#### replace\_first \[boolean][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#replace_first-boolean)
Whether replace the first match string. Only used when `is_regex = true`.
#### common options \[string][](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#common-options-string)
Transform plugin common parameters, please refer to [Transform Plugin](/data-integration-with-nexus/nexus-elements/transform/transform-common-options.md) for details
### Example[](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#example)
The data read from source is a table like this:
| name | age | card |
| -------- | --- | ---- |
| Joy Ding | 20 | 123 |
| May Ding | 20 | 123 |
| Kin Dom | 20 | 123 |
| Joy Dom | 20 | 123 |
We want to replace the char to `_` at the `name` field. Then we can add a `Replace` Transform like this:
```
transform {
Replace {
source_table_name = "fake"
result_table_name = "fake1"
replace_field = "name"
pattern = " "
replacement = "_"
is_regex = true
}
}
```
Then the data in result table `fake1` will update to
| name | age | card |
| --------- | --- | ---- |
| Joy\_Ding | 20 | 123 |
| May\_Ding | 20 | 123 |
| Kin\_Dom | 20 | 123 |
| Joy\_Dom | 20 | 123 |
### Job Config Example[](https://seatunnel.apache.org/docs/2.3.7/transform-v2/replace#job-config-example)
```
env {
job.mode = "BATCH"
}
source {
FakeSource {
result_table_name = "fake"
row.num = 100
schema = {
fields {
id = "int"
name = "string"
}
}
}
}
transform {
Replace {
source_table_name = "fake"
result_table_name = "fake1"
replace_field = "name"
pattern = ".+"
replacement = "b"
is_regex = true
}
}
sink {
Console {
source_table_name = "fake1"
}
}
```