$iszimname

Tests if a character string is a valid object name.

Syntax

$iszimname(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is valid zim object name.

Example

$iszimname(189)

Evaluates to $False.

$iszimname("Fields")

Evaluates to $True.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$islower

$isnumber

$isupper

About Character Literals

About Functional Expressions

$weekday

Determines the day-of-the-week number associated with a specified date value.

Syntax

$weekday(date)

Parameters

datea date, or an expression that evaluates to a date, in the form YYYYMMDD

Return Value

Character string.

Comments

This function extracts day information from standard date values. Date is often the system variable $Date.

Example

$weekday(19981225)

Evaluates to “7”.

$weekday($date+7)

Evaluates to “7” when $Date is 19981225.

See Also

$addmonths

$Date

$day

$dayname

$month

$monthname

$year

About Data Types

About Functional Expressions

$isnumber

Tests if an expression produces a valid number after its evaluation.

Syntax

$isnumber(expression)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is a valid number.

Example

$isnumber(2+3)

Evaluates to $True.

$isnumber($trim(LastName))

Evaluates to $False.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$islower

$isupper

$iszimname

About Character Literals

About Functional Expressions

$toord

Converts a character into its ordinal number value.

Syntax

$toord(char)

Parameters

chara character string, or any expression that evaluates to a character string

Return Value

Number.

Comments

Each of the decimal numbers from 0 to 255 represents a character output by your workstation. $Toord converts the given character to the corresponding decimal number.

If char contains more than one character, only the first character is converted.

The number produced by the $toord function can be converted back to a character by the $tochr function.

Example

$toord(" ")

Evaluates to 32 (on ASCII machines).

$toord(tochr(anynumber ))

Evaluates to any number.

See Also

$toalpha

$tocharacter

$tochr

$todate

About Functional Expressions

Number Literals

$isupper

Tests if the letters in a character string are uppercase.

Syntax

$isupper(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is uppercase, i.e., contains no lowercase letters.

Example

$isupper("aBC")

Evaluates to $False.

$isupper(43)

Evaluates to $True.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$islower

$isnumber

$iszimname

About Character Literals

About Functional Expressions

$isalphabetic

Tests if a character string contains only letters.

Syntax

$isalphabetic(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is alphabetic.

Example

$isalphabetic("abc")

Evaluates to $True.

$isalphabetic("abc1")

Evaluates to $False.

See Also

$isalphanumeric

$isdate

$isdigit

$islower

$isnumber

$isupper

$iszimname

Character Literals

Functional Expressions

$islower

Tests if the letters in a character string are lowercase.

Syntax

$islower(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is lower case, i.e., contains no uppercase letters.

Example

$islower("Abc")

Evaluates to $False.

$islower(34)

Evaluates to $True.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$isnumber

$isupper

$iszimname

About Character Literals

About Functional Expressions

$value

Provides a default value for an expression that can be $Null.

Syntax

$value(expression1,expression2)

Parameters

expression1any expression
expression2any expression

Return Value

Same as the selected expression.

Comments

If expression1 is not $Null, $value returns the value of expression1; otherwise, it returns the value of expression2.

Example

detail line "Employee Number: " $value(EmpNum,"N/A")

Traps $Null values in a report and replaces them with “N/A”.

See Also

About Functional Expressions

CASE

Expressions and the $Null Property

IS [NOT] [$]NULL

$dayname

Determines the day name associated with a specified date value.

Syntax

$dayname(date)

Parameters

datea data, or an expression that evaluates to a date, in the form YYYYMMDD

Return Value

Character string.

Comments

This function extracts day information from standard date values. Date is often the system variable $Date.

The values returned by the $dayname function can be altered with the Language Customizer utility.

Example

$dayname (19991225)

Evaluates to “Saturday”.

$dayname ($date+7)

Evaluates to “Saturday” when $Date is 19991225.

See Also

$Date

$day

$month

$monthname

$weekday

$year

pt_BRPortuguese