Examples of org.apache.poi.ss.formula.functions.Replace

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Replace

org.apache.poi.ss.formula.functions.Replace
An implementation of the Excel REPLACE() function:
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
@author Manda Wilson < wilson at c bio dot msk cc dot org >


        retval[115] = TextFunction.LEFT;
        retval[116] = TextFunction.RIGHT;
        retval[117] = TextFunction.EXACT;
        retval[118] = TextFunction.TRIM;
        retval[119] = new Replace();
        retval[120] = new Substitute();
        retval[121] = new Code();


        retval[124] = TextFunction.FIND;

View Full Code Here

        retval[114] = TextFunction.PROPER;
        retval[115] = TextFunction.LEFT;
        retval[116] = TextFunction.RIGHT;
        retval[117] = TextFunction.EXACT;
        retval[118] = TextFunction.TRIM;
        retval[119] = new Replace();
        retval[120] = new Substitute();
        retval[121] = new Code();


        retval[124] = TextFunction.FIND;

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Replace

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.StringEval

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.