Z API Functions

From ZCubes Wiki
Revision as of 15:35, 14 November 2016 by Devika (talk | contribs) (→‎ENGINEERING2)
Jump to navigation Jump to search

LIST OF ALL FUNCTIONS

STATISTICAL FUNCTIONS1

STATISTICAL FUNCTIONS2

MATH1

MATH2

DATE AND TIME1

DATE AND TIME2

ENGINEERING1

ENGINEERING2

FINANCIAL1: 

* DISC

FINANCIAL2: 

* PRICEDISC

GEOMETRY AND GRAPH1:

GEOMETRY AND GRAPH2:

INFORMATION1:

INFORMATION2: 

* SOT

* SOW

* XMLSET

LOGICAL1: 

* BITAND

DATABASE AND LIST MANAGEMENT1:

DATABASE AND LIST MANAGEMENT2:

LOOKUP AND REFERENCE1:

FUNCT - * FUNCT FUNCTIONFROMTEMPLATE - * FUNCTIONFROMTEMPLATE FUNCTION OF - * FUNCTIONOF FUZZY - * FUZZY GETCOLUMN - * GETCOLUMN GETCONVERSION - * GETCONVERSION GETFUNCTION - * GETFUNCTION GETFUNCTION SET - * GETFUNCTIONSET GET GPS -* GETGPS GETJSON - * GETJSON GET LINE- * GETLINE GET NUMBER TAIL - * GETNUMBERTAIL GET REAL OR COMPLEX - * GETREALORCOMPLEX GET ROW - * GETROW GET SERIES - * GETSERIES GMAP - * GMAP GOALSEEK - * GOALSEEK GROUP - * GROUP HLOOKUP - * HLOOKUP HVLOOKUP - * HVLOOKUP INDEX - * INDEX INDIRECT - * INDIRECT INFO - * INFO INTEG - * INTEG LIST COLUMN LABELS - * LISTCOLUMNLABELS LIST COLUMNS - * LISTCOLUMNS LIST ROWS - * LISTROWS LIST UNIQUE - * LISTUNIQUE LISTV - * LISTV LOOKUP - * LOOKUP LOOP MEDIA - * LOOPMEDIA MLANGUAGE LOOKUP - * MLANGUAGELOOKUP NUMBER EIGHT - * NUMBEREIGHT NUMBER FIVE - * NUMBERFIVE NUMBER FOUR - * NUMBERFOUR NUMBER NINE - * NUMBERNINE NUMBER ONE - * NUMBERONE NUMBER SEVEN - * NUMBERSEVEN NUMBER SIX - * NUMBERSIX NUMBER TEN - * NUMBERTEN NUMBER THREE - * NUMBERTHREE NUMBER TWO - * NUMBERTWO NUMBER ZERO - * NUMBERZERO ONE - * ONE ONE BY -* ONEBY PARSE - * PARSE PARSE LISP - * PARSELISP PARSE NUMBER - * PARSENUMBER PARSE SQL - * PARSESQL PARSESTRING WITHOUT PARANTHESIS - * PARSESTRINGWITHOUTPARANTHESIS PASTE COLUMNS - * PASTECOLUMNS PASTE ROWS - * PASTEROWS PAUSE - * PAUSE QUOTE - * QUOTE ROW - * ROW ROWS - * ROWS ROW WITH - * ROWWITH SMILE - * SMILE UNDEFINED - * UNDEFINED UPTO - * UPTO VLOOKUP - * VLOOKUP


Lookup and Reference2: ANALYZE - * ANALYZE ASSIGN- * ASSIGN ASYNC ITERATE* ASYNCITERATE ATTRTOPROP - * ATTRTOPROP CASE - * CASE CASEIF - * CASEIF CDR - * CDR EFFECT COLORBOOK - * EFFECTCOLORBOOK EFFECTEDGEDETECTION - * EFFECTEDGEDETECTION EFFECTEDGEDETECTIONALGORITHM - * EFFECTEDGEDETECTIONALGORITHM EFFECTGLASS - * EFFECTGLASS EFFECTGLASSBOX - * EFFECTGLASSBOX EFFECT GLASS PATTERN -* EFFECTGLASSPATTERN EFFECTNEONLINES - * EFFECTNEONLINES EFFECTPATTERN - * EFFECTPATTERN EFFECTRIPPLES - * EFFECTRIPPLES GETCELLTD- * GETCELLTD GETLATLONG - * GETLATLONG GKMAPPING - * GKMAPPING PENTATE - * PENTATE QPIVOT - * QPIVOT QPIVOT IN CUBE - * QPIVOTINCUBE SAFE EVAL - * SAFEEVAL STEP LOOP - * STEPLOOP TIMER - * TIMER TIMES - * TIMES TIME STRING - * TIMESTRING TYPE - * TYPE TZ - * TZ XLBETWEEN - * XLBETWEEN XLR BETWEEN - * XLRBETWEEN XPY - * XPY XR BETWEEN - * XRBETWEEN XSY - * XSY

Text and Data1: BADWORDS - * BADWORDS CHAR - * CHAR CHR-* CHR CLAUSES - * CLAUSES CLEAN - * CLEAN CLEAR - * CLEAR CLS -* CLS CODE - * CODE DEFAULT - * DEFAULT DEFAULT NUMBER - * DEFAULTNUMBER DEFAULT PROPER - * DEFAULTPROPER DEFUN - * DEFUN DES - * DES DESCRIBEFUNCTIONCALLMISSING - * DESCRIBEFUNCTIONCALLMISSING DEVARRAY - * DEVARRAY DIM - * DIM DIMENSIONS - * DIMENSIONS DIS - * DIS EIGHTHOF - * EIGHTHOF ESCAPE - * ESCAPE EXTRACT NUMBERS - * EXTRACTNUMBERS EXTRACT TEXT - * EXTRACTTEXT FAIL - * FAIL FIND - * FIND FINDB - * FINDB FINDUNIT - * FINDUNIT FIXCHARS - * FIXCHARS FIXED - * FIXED FIXED BAD- * FIXEDBAD FOR - * FOR FOR ALL- * FORALL FOREACH - * FOREACH FORLOOP - * FORLOOP LEFTB - * LEFTB LEN - * LEN LENB - * LENB LETTERS - * LETTERS LOWER - * LOWER LOWER CASE - * LOWERCASE LZ - * LZ LZWCOMPRESS - * LZWCOMPRESS LZWDECOMPRESS - * LZWDECOMPRESS MID - * MID MIDB - * MIDB MIDDLE - * MIDDLE MIDN - * MIDN MIXED CASE - * MIXEDCASE NOK - * NOK NON FALSE VALUE - * NONFALSEVALUE NON NEGATIVE - * NONNEGATIVE NON POSITIVE - * NONPOSITIVE NON ZERO - * NONZERO NON ZERO VALUE - * NONZEROVALUE NOPE - * NOPE NOW - * NOW NULL - * NULL NULL IF - * NULLIF NUM - * NUM NUMBER - * NUMBER NVL - * NVL OSTYLE - * OSTYLE OUTPUT - * OUTPUT PACK - * PACK PADZEROES - * PADZEROES PHONETIC - * PHONETIC PHONETIC CODES - * PHONETICCODES PRINT - * PRINT PRINT CONVERSION - * PRINTCONVERSION PRINTTAGS - * PRINTTAGS PRINT UNIT TAGS - * PRINTUNITTAGS PRINT WITH UNITS - * PRINTWITHUNITS PROPER - * PROPER PUSH - * PUSH REMOVE TEXT - * REMOVETEXT REPEAT CHAR - * REPEATCHAR REPLACE - * REPLACE REPLACE ARRAY - * REPLACEARRAY REPLACEB - * REPLACEB REPLACE BAD - * REPLACEBAD REPT - * REPT REVERSE - * REVERSE RIGHTB - * RIGHTB RTD - * RTD SEARCH - * SEARCH SEARCHB - * SEARCHB SEARCH BOX SPACE - * SearchBoxSpace SEQ - * SEQ SET VALUE STRING - * SETVALUESTRING SET WHOISUSER - * SETWHOISUSER SLIDER CONTROL - * SLIDERCONTROL SO - * SO SOB - * SOB SOC - * SOC SOH - * SOH SOI - * SOI SOL - * SOL SOLT - * SOLT SOLTWH - * SOLTWH

Retrieved from "http://wiki.zcubes.com/index.php?title=Z_API_Functions&oldid=205622"