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. |