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