Loading TOC...

MarkLogic Server 11.0 Product Documentation
sql: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"

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.