Parse Library: 2.1 Parser Functions: Internal Functions

GEOS SDK TechDocs

2 Parser Functions

2.2 External Functions

The Parse library provides many internal functions. Any application which uses the parse library automatically makes use of these functions. Some of these functions take a single argument; others take a set number of arguments or a variable number.

A listing of currently available functions follows, along with a short description of each one, and a parenthetical description of the function's arguments.

 ABS		Absolute value (One numeric argument)

 ACOS		Arc-cosine (One numeric argument)

 ACOSH		Hyperbolic arc-cosine (One numeric
		argument)

 AND		Boolean AND (Either a list of numbers
		or a cell range--there must be at least
		two numbers)

 ASIN		Arc-sine (One numeric argument)

 ASINH		Hyperbolic arc-sine (One numeric
		argument)

 ATAN		Arc-tangent (One numeric argument)

 ATAN2		Four-quadrant arc-tangent (XXX)

 ATANH		Hyperbolic arc-tangent (One numeric
		argument)

 AVG		Average of arguments (Either a list of
		numbers 	or a cell range--there must be 
		at least 	two numbers)

 CHAR		Translates character-set code into
		character (One Chars argument)

 CHOOSE		Finds value in list at specified offset
		(XXX)

 CLEAN		Removes control characters from a string
		(One string argument)

 CODE		Translates character into character-set 
		code (One string argument (first 
		character will be converted))

 COLS		Returns # of columns in range (XXX)

 COS		Cosine (One numeric argument)

 COSH		Hyperbolic cosine (One numeric argument)

COUNT		Returns number of items in list (Any
		number of arguments)

 CTERM		Returns time for an investment to reach
		a specified value (XXX)

 DDB		Depreciation over a period (XXX)

DEGREES		Converts radians to degrees (XXX)

 ERR		Returns error PSEE_GEN_ERR (XXX)

 EXACT		Tests if two strings match (Two string
		arguments)

 EXP		Exponentiation (One numeric argument)

 FACT		Factorial (XXX)

 FALSE		Returns false (0.0) (XXX)

 FIND		Returns position in string where 
		substring first occurs (Three
		arguments: string to find, string to
		search, starting offset (0 to start
		with the first character))

 FV		Future value of investment (XXX)

 HLOOKUP		Finds a value in a horizontal lookup 
		table (XXX)

 IF		IF(<cond>,x,y) = x if <cond> is true, 
		else y (like C's "<cond> ? x : y") (XXX)

 INDEX		Finds value at specified offset in a 
		range (XXX)

 INT		Rounds to next lowest integer (One
		numeric argument)

 IRR		Internal rate of return (XXX)

 ISERR		True if argument is error (XXX)

 ISNUMBER		True if argument is number (XXX)

 ISSTRING		True if argument is string (XXX)

 LEFT		Returns first characters in string (Two
		arguments: string, number of letters)

 LENGTH		Returns length of string (One string 
		argument)

 LN		Natural log (One numeric argument)

 LOG		Log to base 10 (One numeric argument)

 LOWER		Converts string to all-lowercase (One
		string argument)

 MAX		Returns largest of arguments (XXX)

 MID		Returns characters from middle of
		string (Three arguments: string, 
		starting offset (0 is first character), 
		desired string length)

 MIN		Returns smallest of arguments (XXX)

 MOD		Modulo arithmetic (XXX)

 N		Returns value of first cell in range
		(XXX)

 NA		Returns error PSEE_NA (XXX)

 NPV		Returns net present value of future 
		cash flows (XXX)

 OR		Boolean OR (XXX)

 PI		Returns 3.1415926... (XXX)

 PMT		Calculates # of payments to pay off a 
		debt (XXX)

 PRODUCT		Returns product of arguments (XXX)

 PROPER		Converts string to "Proper 
		Capitalization" (One string argument)

 PV		Calculates present value of an 
		investment (XXX)

 RADIANS		Converts degrees to radians (XXX)

RANDOM		Generates random number between 0 and 1 
		(XXX)

 RANDOMN		Generates random integer below a 
		specified ceiling (XXX)

 RATE		Calculates interest rate needed for 
		investment to reach specified value 
		(XXX)

 REPEAT		Returns string made of repeated 
		argument string (Two arguments: string
		to repeat, number of times to repeat)

 REPLACE		Replaces characters in a string (Four
		arguments: original string, offset of
		first character to replace (0 is the
		first character), number of characters
		to replace, replacement string)

 RIGHT		Returns last characters in a string
		(Two arguments: original string,
		desired length of returned string)

 ROUND		Rounds number to specified precision 
		(XXX)

 ROWS		Returns number of rows in range (XXX)

 SIN		Sine (One numeric argument)

 SINH		Hyperbolic-sine (One numeric argument)

 SLN		Calculates straight-line depreciation 
		(XXX)

 SQRT		Square-root (One numeric argument)

 STD		Calculates standard deviation (XXX)

 STDP		Standard deviation of entire population 
		(XXX)

 STRING		Converts number into string (Two
		numeric arguments: number to convert,
		number of decimal places (between 0 and 
		DECIMAL_PRECISION))

 SUM		Returns sum of arguments (XXX)

 SYD		Sum-of-years'-digits depreciation (XXX)

 TAN		Tangent (sine/cosine) (One numeric
		argument)

 TANH		Hyperbolic tangent (sinh/cosh) (One
		numeric argument)

 TERM		Returns number of payments needed to 
		reach future value (XXX)

 TRIM		Removes leading, trailing, and 
		consecutive spaces from a string (One
		string argument)

 TRUE		Returns TRUE (1.0) (XXX)

 TRUNC		Removes fractional part; rounds towards
		zero (One numeric argument)

 UPPER		Converts all letters in string to
		uppercase (One string argument)

 VALUE		Converts string to number (One string
		argument)

GEOS SDK TechDocs

2 Parser Functions

2.2 External Functions