Open topic with navigation
TIBCO Scribe® Insight FunctionsTIBCO Scribe® Insight includes a rich function library. A brief description
of each function is available by highlighting a function in the Edit
Formula dialog box . This section provides detailed descriptions and
syntax for each function.
ABS
ALIASLIST
AND
ASC
AVERAGE
CDATA
CEILING
CHAR
CHOOSE
CLEAN
CODE
COMPUTERNAME
CONCATENATE
CONVERTDATETIME
COUNT
COUNTA
DATE
DATE2JULLIANDATEJDE
DATEADD
DATEDIFF
DATEPART
DATETIME2JULIANDATE
DATEVALUE
DAY
DAYOFYEAR
DAYS360
DBCS
DBLOOKUP
DBLOOKUP2
DBLOOKUP2NOCACHE
DBLOOKUPNOCACHE
DBLOOKUPCached
DBLOOKUPDEFAULT
DBLOOKUPDEFAULT2
DBLOOKUPLIST
DBLOOKUPLIST2
DBNAME
DEC2HEX
DEC2OCT
DOLLAR
EDATE
ENDJOBFAILED
ENDJOBFAILEDMSG
ENDJOBRETRY
ENDJOBRETRYMSG
ENDJOBSUCCESSCOMMIT
ENDJOBSUCCESSROLLBACK
EOMONTH
ERROR.TYPE
EXACT
FAILROW
FAILROWMSG
FALSE
FILELOOKUP
FIND
FIRSTNAMEMATCH
FIXED
FKEYSUBST
FLOOR
FORMAT
GETLASTRUNDATE
GETLASTRUNDATEUTC
GETNAMEDVALUE
GETROWERROR
GOTOSTEP
GUID
HEX2DEC
HEX2OCT
HTML2TEXT
HOUR
IF
IN
INT
ISBLANK
ISDATE
ISEMAILADDRESS
ISEMPTY
ISERROR
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISPICKLISTVALUE
ISTEXT
JULIANDATE2DATETIME
JULIANDATEJDE2DATE
LEFT
LEN
LOCAL2UTC
LOWER
MAX
MID
MIN
MINUTE
MOD
MONTH
MONTHNAME
N
NA
NEXTITEMNUMBER
NEXTROW
NEXTTRANSNUMBER
NEXTTRANSNUMBERN
NOT
NOW
OCT2DEC
OCT2HEX
OR
OSPATHTOUNC
PAD
PARSE
PARSEADDR
PARSENAME
PRODUCT
PROPER
RAND
REGEXMATCH
REGEXREPLACE
REPLACE
REPT
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROWNUM
SEARCH
SECOND
SELECTCASE
SEQNUM
SEQNUMN
SETNAMEDVALUE
SETNAMEDVALUEIF
SIGN
SIZE
SKIPSTEP
SOUNDEX
SPLITFILENAME
SQLQUERY
SQLQUERY2
SQLQUERYDEFAULT
SQLQUERYDEFAULT2
STRIP
STRIPCOMPANY
STRIPCOMPANYSUFFIX
STRIPEX
SUBSTITUTE
SUM
SUMROWS
T
TEXT
TIME
TIMEVALUE
TODAY
TRIM
TRIMX
TRUE
TRUNC
TYPE
UPPER
USERNAME
UTC2LOCAL
VALUE
VALUEMAPLOOKUPA
VALUEMAPLOOKUPB
WEEKDAY
WEEKDAYNAME
XLSLOOKUP
XMLLOOKUP
XMLXPATH
XMLXREF
XREFLOOKUP
XREFLOOKUP_AKEY
XREFLOOKUP_BKEY
XREFLOOKUPINTERNAL
XREFLOOKUPLOCK_AKEY
XREFLOOKUPLOCK_BKEY
XREFLOOKUPNOLOCK_AKEY
XREFLOOKUPNOLOCK_BKEY
YEAR
