public final class Replace extends Fixed4ArgFunction
Replaces part of a text string based on the number of characters
you specify, with another text string.
Syntax:
REPLACE(oldText, startNum, numChars, newText)
oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section
Constructor and Description |
---|
Replace() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2,
ValueEval arg3)
|
evaluate
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.