<< F_LINEWRAP U_LINEWRAP | IBExpert UDF Functions | F_REPLACESTRING (F_REPLACESTRING4, F_REPLACESTRING8) F_BIGREPLACESTRING U_REPLACESTRING >>

F_REPLACE (F_REPLACE4, ...8) F_BIGREPLACE

 
substitutable with REPLACE

• compatibility to FreeUDFLibC
• Compatible with UTF-8
• Input VARCHAR(32760) string where a character string had to be exchanged, VARCHAR(254) old string, VARCHAR(254) new string
• Output VARCHAR(32760) string with replaced characters from parameter 2 with characters from parameter 3

Easy version of the function F_REPLACESTRING without the posibility to change the string more than one time and independent of upper and lower case.

Example

 SELECT 'This is a test two Attempt three TEST' AS ISCORRECT, F_REPLACE('This is a Test two Test three TEST', 'Test', 'Attempt') FROM RDB$DATABASE;

Expected results:

 ISCORRECT                                          F_REPLACE
 ===================================== ================================================
 This is a test two Attempt three TEST This is a test two Attempt three TEST  

Example

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

Expected results:

 ISCORRECT F_REPLACE
 ========= =========================================================
 <null>    <null>

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