Name
replace — Searches for an substring and replace its occurrences with other substring.
Synopsis
string
replace
(
|
txt string , |
| search_strg string , | |
replace_strg
string
); |
Description
The function searches for all occurrences of a search_strg
in
txt
and replaces every occurrence with replace_strg
.
An error is signalled if search_strg
is empty.
Parameters
txt
Text to process.
search_strg
Substring to search for
txt
.
replace_strg
Substring to replace
search_strg
in
txt
.
Return Types
String.
Errors
Table 24.149. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| XP001 | XPF08 | Empty string passed as argument 2 to XPATH function replace() | It is impossible to search for an empty substring. |
| XP001 | XPF14 | The result of XPATH function replace() is too long | If the function replaces short substring with longer one, the result is longer than the original string and may exceed 10Mb limit. |
Examples
Example 24.615.
Replace all occurrences of 'http://www.example.com/' with '/webrobot/'
replace( '<A HREF="http://www.example.com/index.html">Home</A>', 'http://www.example.com/', '/webrobot/' )