This shows you the differences between two versions of the page.

Link to this comparison view

expression function - number to letters [2016/09/14 14: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. 
 +===== 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"​.
expression function - number to letters.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019