XQuery replace Function

XQuery replace Function

The replace function replaces the matched input string with a given string.

Syntax

replace($input, $regex, $string)

Input Parameters

• $input is the input string.
• $regex is the regular expression.
• $string is the string to replace original string.

Example

XQuery Expression

let $input := 'Chapter 1 ... Chapter 2'
return ( replace($input, "Chapter (\d)", "Section $1.0"))

Output

Section 1.0 ... Section 2.0