![]() |
|
![]() |
RowIdToRowNum FunctionThe RowIdToRowNum function in Expression Builder converts an alphanumeric Row ID to a numeric format. NOTE: Row IDs are generated by Siebel CRM On Demand using a proprietary algorithm, and have full referential integrity across the Siebel CRM On Demand database. The algorithm uses Base-36 encoding, a positional numeral system where the radix is 36. Using 36 as the radix allows the digits to be represented by the numbers 0-9 and the letters A-Z, which is an optimized, case-insensitive alphanumeric numeral system, based on ASCII characters. SyntaxRowIdToRowNum('row_id') Result TypeString ArgumentsThe following table describes the arguments for the function.
ExamplesThe following example: RowIdToRowNum('12-6RX8L'). returns the value 38-8021253. The following example: RowIdToRowNum('12-Y09KG') returns the value 38-57119344. If the <AccountID> field contains '12-Y09KG', the following example: RowIdToRowNum('<AccountID>') returns the value 38-57119344. Related InformationSee the following topics for related Expression Builder information: | ||||||
Published May 2008 |