Temenos T24 Infobasic Built in Functions

Infobasic has a number of built in functions that help in rapid code development. Some of the commonly used built in functions are listed below.

LEN
COUNT
DCOUNT
UPCASE
DOWNCASE
CHANGE
OCONV

LEN

Use the LEN function to return the number of characters in a string.
Example

Var1 = LEN("TEMENOS")
;*// Var1 now have 8 value in it

COUNT

Use the COUNT function to return the number of times a substring is repeated in a string value.
Example

Var1 = "abc,def,ghi"
Var2 = COUNT(Var1,",")
;*//The COUNT function is used to count the number of "," in the string held in the variable var1

DCOUNT

Use the DCOUNT function to return the number of delimited fields in a data string.
Example

Var1 = "abc,def,ghi"
Var2 = DCOUNT(Var1,",")
;*//The DCOUNT function is used to count the number of fields delimited by the delimiter "," in the string held in the variable var1

UPCASE

Use the UPCASE function to convert the passes string to UPPER CASE.
Example

Var1 = UPCASE("temenos")
;*// var1 is now TEMENOS

DOWNCASE

Use the DOWNCASE function to convert the passed string to lower case.
Example

Var1 = DOWNCASE("TEMENOS")
;*// var1 is now temenos

CHANGE

Use the CHANGE function to replace a substring in expression with another substring. If you do not specify occurrence, each occurrence of the substring is replaced.
Example

Var1 = CHANGE("TEMENOOS","OO","O")
;*// Var1 is now TEMENOS

OCONV

Use the OCONV function to convert string to a specified format for external output. The result is always a string expression.
Example

DATE = OCONV('9166',"D2");
;*// DATE have value 3 Feb 93