meta data for this page
  •  

F_TELEFONNR

function from adhoc

Entrypoint telefonnr compatible with UTF-8

Inputs/Outputs

 Input      CSTRING(32760)     Telephone no. as string (or something similar, from which everything is to be removed up to the numbers)
            INTEGER	         defines the amount of numbers at the end to replace with *
 Output     CSTRING(32760)     String without all non numbers

Syntax

 "49" at the beginning is changed to "+49". If the string starts with one "+", this remains. 
 Note:
 This function is necessary for "wildly" formatted telephonenumbers for TAPI to a Telephone(system) which couldn't do this by itsself.
 TestSQL
 SELECT '0232653***' AS ISCORRECT, F_TELEFONNR(' (0232) / 6535-35', 3) FROM RDB$DATABASE;
 SELECT '+001232653***' AS ISCORRECT, F_TELEFONNR('+001 (232) / 6535-35', 3) FROM RDB$DATABASE;
 SELECT '+49232653***' AS ISCORRECT, F_TELEFONNR('+49 (232) / 6535-35', 3) FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_TELEFONNR(NULL, NULL) FROM RDB$DATABASE;