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.143. 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.655.
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/' )