Character Conversion Functions
Description
Functions to convert other data types to strings.
- Name
- Description
- *acp_to_wchar Function
Convert ACP encoded text to wide-character text.
- *BIN_TO_HTML Function
Convert from binary to html.
- *BIN_TO_RTF Function
Convert from binary to rtf.
- *blob_to_wchar Function
Convert binary data to wide-character text.
- *chartocharset Function
Given the text arguments locale - return the charset to use.
- *chartocodepage Function
Given the text arguments locale - return the codepage.
- *chartounicode Function
Return the unicode value for the character (given text's code page).
- *from_roman Function
Convert Roman numerals to number.
- *Gunzip_Text Function
Uncompress blob using gzip.
- *Gzip_text Function
Compress string using gzip.
- *HTML_TO_BIN Function
Convert from html to binary.
- *HTML_TO_PLAIN Function
Convert from html to plain text.
- *HTML_TO_RTF Function
Convert from html to rtf.
- *html_to_text Function
Get all the selectable text from html.
- *lf_to_crlf Function
Converts single LF's to CR-LF pairs.
- *PLAIN_TO_HTML Function
Convert from plain text to html.
- *PLAIN_TO_RTF Function
Convert from plain text to rtf.
- *RTF_TO_BIN Function
Convert from rtf to binary.
- *RTF_TO_HTML Function
Convert from rtf to html.
- *RTF_TO_PLAIN Function
Convert from rtf to plain text.
- *TO_HEX Function
Convert binary data to hexadecimal data.
- *TO_OCTAL Function
Convert binary data to octal data.
- *to_roman Function
Convert numeric value to roman numerals.
- *unicode_to_utf8 Function
Convert unicode number to UTF8 encodeing.
- *unit_convert Function
Convert a scalar size/position between units, optional device units.
- *utf8_to_unicode Function
Convert utf8 encoded character to unicode number.
- *utf8_to_wchar Function
Convert UTF8 encoded text to wide-character text.
- *wchar_to_acp Function
Convert wide-character text to ACP encoded text.
- *wchar_to_blob Function
Convert wide-character text to binary data.
- *wchar_to_utf8 Function
Convert wide-character text to UTF8 encoded text.
- A5_ANSIDATE Function
Converts a date string to an ANSI C asctime() formatted date (Day Mon d hh:mm:ss yyyy)
- a5_short_type_to_long Function
Converts a short data type to a long type - e.g. 'c' to 'character'. If type = 'list' shows all available data types.
- A5_WORD_MERGE Function
Mailmerge into Microsoft Word. Choice = "new" or "template" for an existing template. Mergedata is a comma delimited txt fie.
- a5_word_merge_dotnet Function
Merges data into an MS Word Template document. Requires Visual Studio Tools for Office.
- ANSI_TO_OEM Function
Interface to windows ansi_to_oem function
- ASC Function
Returns the ASCII value of a character.
- CHR Function
Converts a numeric expression to a character expression.
- CHR_MULTI Function
Generates a string using the specified ASCII value repeated multiple times.
- convert_a4_to_a5 Function
Convert a4 data files to a5 format, flags: X- convert extended characters, M-convert memo files, D-DBT to FPT.
- convert_acp_to_utf8 Function
Convert ascii encoded text to utf8.
- convert_lf_to_crlf Function
For long strings that use LF as a line delimiter, convert to CRLF
- convert_utf8_to_acp Function
Convert utf8 encoded text to ascii.
- CRLF Function
Returns cr-lf(s).
- DEC_TO_HEX Function
Converts a decimal value to hexadecimal.
- HEX_TO_DEC Function
Converts a hexadecimal value to a decimal number.
- INT Function
Returns the integer part of a number.
- OEM_TO_ANSI Function
Interface to windows oem_to_ansi function
- S_QUOTE Function
Special quote. Quotes char values, makes logical values into ".T." or ".F.", puts date values in curly braces.
- STR Function
Converts a number to a character string.
- VAL Function
Converts a character string to a numeric value.
- ZBLANK Function
Converts a number to a blank character string if the number is zero.
Related Functions
- *HTML_ESCAPE()
Encodes ordinary text into HTML format.
- A5_RFC1123DATE()
Takes a date, either as a time or character, and converts it to a string following the RFC 1123 format.
- A5_RFC822DATE()
Takes a date, either as a time or character, and converts it to a string, following the RFC 822 format.
- A5_RFC850DATE()
Takes a date, either as a time or character, and converts it to a string, following the RFC 850 format.
- A5_T_FROM_RFCDATE()
Converts a date string formatted by A5_ANSIDATE(), A5_RFC1123DATE(), A5_RFC822DATE(), or A5_RFC850DATE() into a time-date value.
- CDATE()
Converts a date to a formatted character string in the form YYYYMMDD.
- CDOW()
Returns a character string containing the name of the day of the week for the specified date.
- CMONTH()
Returns the name of the month for the specified date.
- CHAR_TO_BLOB()
Returns the blob equivalent of a character string.
- CONVERT_TYPE()
Converts variables from one type to another, preserving the data if possible.
- CTOD()
Converts a character string containing date information to a Date value.
- CTODT()
Converts a date and time string to a time value.
- CTOT()
Converts a time string to a time value.
- CYEAR()
Returns a character string containing the year in the form YYYY based on the specified date value.
- TIME()
Returns a formatted string containing the system time.
- split()
Splits a character strings into multiple sub strings and stores them in an array.
- TOTIME()
Returns a formatted character string containing a time based on the specified number of seconds past midnight.
See Also