F_CONVERTSYMBOLS

<< F_REPLACESTRING (F_REPLACESTRING4, F_REPLACESTRING8) F_BIGREPLACESTRING U_REPLACESTRING | IBExpert UDF Functions | F_REVERSE U_REVERSE >>

F_CONVERTSYMBOLS

 
  • input/output-compatibility to rFunc (CONVERTSYMBOLS, LONGCONVERTSYMBOLS)
 
U_CONVERTSYMBOLS
  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(32760) String in which characters should be replaced, VARCHAR(254) String 2 with all characters to be replaced, VARCHAR(254) String 3 with characters to replace with characters at the same place in string 2
  • Output VARCHAR(32760) String in which all characters where replaced with characters from string 3

Example

 SELECT '(a+ab)-abc*a+b=c' AS ISCORRECT, F_CONVERTSYMBOLS('(1+12)-123*1+2=3', '123', 'abc') FROM RDB$DATABASE;

Expected results:

 ISCORRECT        F_CONVERTSYMBOLS                                                                                                                                                                                                                                 
 ================ =================================================
 (a+ab)-abc*a+b=c (a+ab)-abc*a+b=c 

Example

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

Expected results:

 ISCORRECT F_CONVERTSYMBOLS                                                                                                                                                                                                                                    
 ========= =======================================================
 <null>    <null> 

back to top of page
<< F_REPLACESTRING (F_REPLACESTRING4, F_REPLACESTRING8) F_BIGREPLACESTRING U_REPLACESTRING | IBExpert UDF Functions | F_REVERSE U_REVERSE >>