LucidDbAppLib CLEAN PHONE INTERNATIONAL

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Output 5 Source Code

Syntax

APPLIB.CLEAN_PHONE_INTERNATIONAL ( number_string, flag )

Purpose

Converts an international phone number into a common format.

Parameters

• number_string: Phone number string to be standardized [varchar]
• flag:
  • false - returns the number_string on error
  • true - gives an error message on error.

Output

• [VARCHAR(128)] international phone number in standardized format, null if any inputs are null.

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/phone/CleanPhoneInternationalUdf.java