REPLACE function
The REPLACE/REPLACEB function is one of the text and data functions. Is used to replace a set of characters, based on the number of characters and the start position you specify, with a new set of characters. The REPLACE function is intended for languages that use the single-byte character set (SBCS), while REPLACEB - for languages that use the double-byte character set (DBCS) like Japanese, Chinese, Korean etc.
Syntax
REPLACE(old_text, start_num, num_chars, new_text)
The REPLACE function has the following arguments:
| Argument | Description |
|---|---|
| old_text | The original text to be replaced. |
| start_num | The beginning of the set to be replaced. |
| num_chars | The number of characters to be replaced. |
| new_text | The new text. |
REPLACEB(old_text, start_num, num_bytes, new_text)
The REPLACEB function has the following arguments:
| Argument | Description |
|---|---|
| old_text | The original text to be replaced. |
| start_num | The beginning of the set to be replaced. |
| num_bytes | The number of characters to be replaced, based on bytes. |
| new_text | The new text. |
Notes
The REPLACE function is case-sensitive.
How to apply the REPLACE/REPLACEB function.
Examples
The figure below displays the result returned by the REPLACE function.
