Converting data types

Data must be the correct type for the operation involved. The following @functions convert data, and test for type.

Function

Description

@Char(number)

Converts an HCL Code Page 850 code number to its corresponding character.

@IsNumber(value)

Returns True (1) if a value is a number or number list.

@IsText(value)

Returns True (1) if a value is a text string or text string list.

@IsTime(value)

Returns True (1) if a value is a time-date or time-date list.

@Text(value)

Converts a value to a text string.

@Text(value ; format)

Converts a numeric or date-time value to a text string according to a specified format.

@TextToNumber(string)

Converts a text string to a number.

@TextToTime(string)

Converts a text string to a date-time value.

@TimeToTextInZone(date-time ; time zone)

Converts a date-time value to a string that includes time zone information.

@TimeZoneToText( time zone)

Converts a time zone value to a human-readable string.

@ToNumber(string or value)

Converts a number or text string to a number.

@ToTime(string or date-time value)

Converts a number or date-time value to a date-time value.