Loading TOC...
XQuery sql:insert

MarkLogic 9 Product Documentation
sql.insert

sql.insert(
   str as String,
   start as Number,
   length as Number,
   str2 as String
) as 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.