REPLACE/REPLACEB 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.
Return to previous page