Rtf template functions

LOWER returns char , with all letters lowercase. The return value is the same datatype as char. UPPER returns char , with all letters uppercase. The "length" function returns the length of char. All exprs after the first are implicitly converted to the datatype of the first expr before the comparison.

LEAST returns the least of the list of exprs. Method to get the next element in the current group. Returns the element that occurs after the element named.

Method to get the previous element in the current group. Returns the element that occurs before the element named. Sets a value in a hash table. Returns the value at the specified index of the hash table.

This function enables the conversion of numbers to words for RTF template output. This is a common requirement for check printing. For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which governs the number of digits after the decimal point.

The currency code does not generate a currency symbol in the output. Table B-4 displays the example function as entered in an RTF template and the returned output. Skip Headers. It covers the following topics: Section B. Enter the text to be trimmed, the function returns the trimmed text. Any number precisionOrCurrency For this attribute you can specify either the precision, which is the number of digits after the decimal point; or the currency code, which governs the number of digits after the decimal point.

An integer, such as 2; or a currency code, such as 'USD'. All rights reserved. Book List. Contact Us. Removes spaces in a string. Reads date in one format and creates in another format. Book List. Contact Us. The lpad function pads the left side of a string with a specific set of characters.

The rpad function pads the right side of a string with a specific set of characters. The syntax for the decode function is: decode expression, search, result [,search, result] The instr function returns the location of a substring in a string. The first position in the string is 1.

The substr function allows you to extract a substring from a string. The first position in the string is always 1. In this case we have four groups:. Looking for intelligent technological solutions? Seeking consultation on your upcoming projects? Need a quote for services? Previous Next. Article continued after break. Contact Us. Sample XML that was generated. It is the flat XMLwhich has no aggregations and grouping.