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