MarkLogic 9 Product Documentationsql:insert
sql:insert( $str as xs:string, $start as xs:double, $length as xs:double, $str2 as xs:string ) as xs:string
Summary
Returns a string that that is the first argument with length characters removed starting at start and the second string has been inserted beginning at start.
| Parameters | |
|---|---|
| str | The string to manipulate. |
| start | The starting position where characters will be inserted. |
| length | The number of characters to be removed. |
| str2 | The string to insert. |
Example
sql:insert("abcdef",2,1,"(REDACTED)")
=> "ab(REDACTED)def"