F_DIGITS

<< F_TELEFONNR | IBExpert UDF Functions | F_STR2EXCEL >>

F_DIGITS

 
  • compatibility to GrUDF
  • Compatible with UTF-8
  • Input VARCHAR(32760) String from which all non-numbers had to be remove
  • Output VARCHAR(32760) String with removed all non-numbers (e.g. for TAPI)

Example

 SELECT '0232653535' AS ISCORRECT, F_DIGITS(' (0232) / 6535-35') FROM RDB$DATABASE;

Expected results:

 ISCORRECT  F_DIGITS                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
 ========== ===============================================================================
 0232653535 0232653535 

Example

 SELECT NULL AS ISCORRECT, F_DIGITS(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_DIGITS
 ========= ===============================================================================
 <null>    <null>                  

back to top of page
<< F_TELEFONNR | IBExpert UDF Functions | F_STR2EXCEL >>