text:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<TITLE>
TextFunction (POI API Documentation)
</TITLE>

<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../../stylesheet.css" TITLE="Style">

      Overview
      Package
    Class
      Use
      Tree
      Deprecated
      Index
      Help

 PREV CLASS
 NEXT CLASS

  FRAMES
 NO FRAMES

  All Classes

  SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.poi.ss.formula.functions

Class TextFunction

java.lang.Object
  org.apache.poi.ss.formula.functions.TextFunction

All Implemented Interfaces:
Function

public abstract class TextFunction
extends java.lang.Object
implements Function

Author:

Amol S. Deshmukh < amolweb at ya hoo dot com >, Josh Micich, Stephen Wolke (smwolke at geistig.com)

Field Summary

static Function
CHAR

          Returns the character specified by a number.

static Function
CLEAN

          An implementation of the CLEAN function:
 In Excel, the Clean function removes all non-printable characters from a string.

static Function
CONCATENATE

static Function
EXACT

static Function
FIND

          Implementation of the FIND() function.

protected static DataFormatter
formatter

static Function
LEFT

static Function
LEN

static Function
LOWER

static Function
MID

          An implementation of the MID function

 MID returns a specific number of
 characters from a text string, starting at the specified position.

static Function
PROPER

          Implementation of the PROPER function:
 Normalizes all words (separated by non-word characters) by
 making the first letter upper and the rest lower case.

static Function
RIGHT

static Function
SEARCH

          Implementation of the FIND() function.

static Function
TEXT

          An implementation of the TEXT function

 TEXT returns a number value formatted with the given number formatting string.

static Function
TRIM

          An implementation of the TRIM function:
 Removes leading and trailing spaces from value if evaluated operand
  value is string.

static Function
UPPER

Constructor Summary

TextFunction()

Method Summary

 ValueEval
evaluate(ValueEval[] args,
         int srcCellRow,
         int srcCellCol)

protected static double
evaluateDoubleArg(ValueEval arg,
                  int srcCellRow,
                  int srcCellCol)

protected abstract  ValueEval
evaluateFunc(ValueEval[] args,
             int srcCellRow,
             int srcCellCol)

protected static int
evaluateIntArg(ValueEval arg,
               int srcCellRow,
               int srcCellCol)

protected static java.lang.String
evaluateStringArg(ValueEval eval,
                  int srcRow,
                  int srcCol)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

formatter

protected static final DataFormatter formatter

CHAR

public static final Function CHAR

Returns the character specified by a number.

LEN

public static final Function LEN

LOWER

public static final Function LOWER

UPPER

public static final Function UPPER

PROPER

public static final Function PROPER

Implementation of the PROPER function:
 Normalizes all words (separated by non-word characters) by
 making the first letter upper and the rest lower case.

 This is nearly equivalent to toTitleCase if the Java language had it

TRIM

public static final Function TRIM

An implementation of the TRIM function:
 Removes leading and trailing spaces from value if evaluated operand
  value is string.
 Author: Manda Wilson < wilson at c bio dot msk cc dot org >

CLEAN

public static final Function CLEAN

An implementation of the CLEAN function:
 In Excel, the Clean function removes all non-printable characters from a string.

 Author: Aniket Banerjee(banerjee@google.com)

MID

public static final Function MID

An implementation of the MID function

 MID returns a specific number of
 characters from a text string, starting at the specified position.

 Syntax:
 MID(text, start_num,
 num_chars)

 Author: Manda Wilson < wilson at c bio dot msk cc dot org >

LEFT

public static final Function LEFT

RIGHT

public static final Function RIGHT

CONCATENATE

public static final Function CONCATENATE

EXACT

public static final Function EXACT

TEXT

public static final Function TEXT

An implementation of the TEXT function

 TEXT returns a number value formatted with the given number formatting string.
 This function is not a complete implementation of the Excel function, but
  handles most of the common cases. All work is passed down to
  DataFormatter to be done, as this works much the same as the
  display focused work that that does.

 Syntax:
 TEXT(value, format_text)

FIND

public static final Function FIND

Implementation of the FIND() function.

 Syntax:

 FIND(find_text, within_text, start_num)

 FIND returns the character position of the first (case sensitive) occurrence of
 <tt>find_text</tt> inside <tt>within_text</tt>.  The third parameter,
 <tt>start_num</tt>, is optional (default=1) and specifies where to start searching
 from.  Character positions are 1-based.

 Author: Torstein Tauno Svendsen (torstei@officenet.no)

SEARCH

public static final Function SEARCH

Implementation of the FIND() function.

 Syntax:

 SEARCH(find_text, within_text, start_num)

 SEARCH is a case-insensitive version of FIND()

Constructor Detail

TextFunction

public TextFunction()

Method Detail

evaluateStringArg

protected static java.lang.String evaluateStringArg(ValueEval eval,
                                                    int srcRow,
                                                    int srcCol)
                                             throws EvaluationException

Throws:

EvaluationException

evaluateIntArg

protected static int evaluateIntArg(ValueEval arg,
                                    int srcCellRow,
                                    int srcCellCol)
                             throws EvaluationException

Throws:

EvaluationException

evaluateDoubleArg

protected static double evaluateDoubleArg(ValueEval arg,
                                          int srcCellRow,
                                          int srcCellCol)
                                   throws EvaluationException

Throws:

EvaluationException

evaluate

public final ValueEval evaluate(ValueEval[] args,
                                int srcCellRow,
                                int srcCellCol)

Specified by:
evaluate in interface Function

Parameters:
args - the evaluated function arguments.  Empty values are represented with
 BlankEval or MissingArgEval, never null.
srcCellRow - row index of the cell containing the formula under evaluation
srcCellCol - column index of the cell containing the formula under evaluation

Returns:
The evaluated result, possibly an ErrorEval, never null.
 Note - Excel uses the error code #NUM! instead of IEEE NaN, so when
 numeric functions evaluate to Double.NaN be sure to translate the result to ErrorEval.NUM_ERROR.

evaluateFunc

protected abstract ValueEval evaluateFunc(ValueEval[] args,
                                          int srcCellRow,
                                          int srcCellCol)
                                   throws EvaluationException

Throws:

EvaluationException

      Overview
      Package
    Class
      Use
      Tree
      Deprecated
      Index
      Help

 PREV CLASS
 NEXT CLASS

  FRAMES
 NO FRAMES

  All Classes

  SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

                Copyright 2017 The Apache Software Foundation or
        its licensors, as applicable.

redpajama_set_name: RedPajamaGithub


text:
namespace x86
{
  extern void init_libc(uint32_t magic, uint32_t address);
}

extern "C" {
  void kernel_sanity_checks();
  uintptr_t __syscall_entry();
}

#define LL_ASSERT(X) if (!(X)) { kprint("Early assertion failed: " #X "\n");  asm("cli;hlt"); }


text:
-- =====================================================
-- Author:		Stephen Quin
-- Create date: 09/07/2013
-- Description:	Gets all the current insurance policies
-- =====================================================
CREATE PROCEDURE [dbo].[h3giInsuranceGetPolicies]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	SELECT Id, Name, AnnualPrice, MonthlyPrice, Description
	FROM h3giInsurancePolicy
	WHERE Deleted = 0
END

GRANT EXECUTE ON h3giInsuranceGetPolicies TO b4nuser
GO