- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - number to letters [2016/09/14 18:19] |
expression function - number to letters [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Number to Letters (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Number to Letters** function (NUMBER_TO_LETTERS) returns capitalized latin characters that correspond to the number starting with 0. | ||
+ | |||
+ | {{::number_to_letters_initial.png?direct&600|}} | ||
+ | ===== Parameters ===== | ||
+ | The **Number to Letters** function has one required parameter: | ||
+ | |||
+ | ==== String ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|field]] value or positive number | ||
+ | |||
+ | Either use the use the [[Query Builder]] to choose a field that contains a positive number or use type a value to enter a positive number. While it is technically possible to use a text string with this function it is not recommended. | ||
+ | |||
+ | ===== Output ===== | ||
+ | |||
+ | The output of the **Number to Letters** function is a string of capitalized latin characters corresponding to the number entered starting with 0 = A. A negative number will result in an empty string. | ||
+ | ===== Example ===== | ||
+ | |||
+ | This function can be useful when creating simple alphabetic identifiers. For example the result of NUMBER_TO_LETTERS(0) is "A", the result of NUMBER_TO_LETTERS(25) is "Z", and the result of NUMBER_TO_LETTERS(30) would be "AE". |