User Guides

Name Arguments Return Description
Chr NUMBER ascii_code TEXT Returns a one-character text value containing the character specified by ascii.
Category: Text Functions
Name: Chr
Arguments: NUMBER ascii_code
Return Type: TEXT
Description: Returns a one-character text value containing the character
specified by ascii.
Examples: Chr(65) will return “A”
ConCat   TEXT Returns the merged text value of all the arguments.
Category: Text Functions
Name: ConCat
Arguments:  
Return Type: TEXT
Description: Returns the merged text value of all the arguments.
Examples: ConCat(“abc”,”def”,”ghi”) returns “abcdefghi”
LTrim TEXT text, [TEXT character_mask] TEXT Strip whitespace (or other characters) from the beginning of a text value.
Category: Text Functions
Name: LTrim
Arguments: TEXT text, [TEXT character_mask]
Return Type: TEXT
Description: Strip whitespace (or other characters) from the beginning of a
text value.
Examples: LTrim(” abc “) will return “abc “
LTrim(“–abc—“, “-“)
will return “abc—“
Num TEXT text NUMBER Converts a text value to number if the text value contains only numeric characters and a decimal
point.
Category: Text Functions
Name: Num
Arguments: TEXT text
Return Type: NUMBER
Description: Converts a text value to number if the text value contains only
numeric characters and a decimal point.
Examples: Num(“8950”) will return 8950 in numeric form
RTrim TEXT text, [TEXT character_mask] TEXT Strip whitespace (or other characters) from the end of a text value.
Category: Text Functions
Name: RTrim
Arguments: TEXT text, [TEXT character_mask]
Return Type: TEXT
Description: Strip whitespace (or other characters) from the end of a text
value.
Examples: RTrim(” abc “) will return ” abc”
RTrim(“–abc—“, “-“)
will return “–abc”
Str DATABASE_FIELD/MIXED variable TEXT Returns text value of a variable.
Category: Text Functions
Name: Str
Arguments: DATABASE_FIELD/MIXED variable
Return Type: TEXT
Description: Returns text value of a variable.
Examples: Str(“12345”) returns “12345” in text form
StrLen TEXT_FIELD/TEXT text NUMBER Returns the length of the given text value.
Category: Text Functions
Name: StrLen
Arguments: TEXT_FIELD/TEXT text
Return Type: NUMBER
Description: Returns the length of the given text value.
Examples: StrLen(“Hello World”) returns 11
SubStr TEXT_FIELD/TEXT text, NUMBER start, [NUMBER length] TEXT Return part of a text value.
Category: Text Functions
Name: SubStr
Arguments: TEXT_FIELD/TEXT text, NUMBER start, [NUMBER length]
Return Type: TEXT
Description: Returns the portion of text value specified by the start and
length parameters.

 

TEXT_FIELD/TEXT text
The input text value. Must be
one character or longer.

INTEGER start
If start is non-negative, the
returned text value will start at the start’th position in text value, counting from
zero. For instance, in the text value ‘abcdef’, the character at position 0 is ‘a’, the
character at position 2 is ‘c’, and so forth.

If start is negative, the returned
text value will start at the start’th character from the end of text value.

If
text value is less than start characters long, FALSE will be returned.

INTEGER
length

If length is given and is positive, the text value returned will
contain at most length characters beginning from start (depending on the length of text
value).

If length is given and is negative, then that many characters will be
omitted from the end of text value (after the start position has been calculated when a
start is negative). If start denotes the position of this truncation or beyond, FALSE
will be returned.

If length is given and is 0, FALSE or NULL, an empty text value
will be returned.

If length is omitted, the substring starting from start until
the end of the text value will be returned.

Examples: substr(“abcdef”, 0, 2) returns “ab”
substr(“abcdef”, -1)
returns “f”
substr(“abcdef”, -2) returns “ef”
substr(“abcdef”, -3, 1) returns
“d”
Trim TEXT text, [TEXT character_mask] TEXT Strip whitespace (or other characters) from the beginning and end of a text value.
Category: Text Functions
Name: Trim
Arguments: TEXT text, [TEXT character_mask]
Return Type: TEXT
Description: Strip whitespace (or other characters) from the beginning and
end of a text value.
Examples: Trim(” abc “) will return “abc”
Trim(“—abc–“, “-“) will
return “abc”