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
Table24.150.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
Example24.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/' )