Print      Open PDF Version of Online Help


Previous Topic

Next Topic

RowIdToRowNum

The RowIdToRowNum function in Expression Builder converts an alphanumeric Row ID to a numeric format.

NOTE: Row IDs are generated by Oracle CRM On Demand using a proprietary algorithm, and have full referential integrity across the Oracle 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.

Syntax

RowIdToRowNum('row_id')

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

row_id

The string literal, field name, or expression that returns an alphanumeric row ID.

Examples

The 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 Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.