F_STRIPSTRING
<< F_REVERSE U_REVERSE | IBExpert UDF Functions | F_STRIPSTRINGHOLD F_HOLDSTRING F_BIGSTRIPSTRINGHOLD U_STRIPSTRINGHOLD >>
F_STRIPSTRING F_BIGSTRIPSTRING
- compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF
U_STRIPSTRING
- function from adhoc
- Compatible with UTF-8
- Input VARCHAR(32760) String 1, VARCHAR(254) String 2 as a list of all characters which are to delete
- Output VARCHAR(32760) String stripped from all characters which are content of parameter 2
Counterpart to F_STRIPSTRINGHOLD and F_HOLDSTRING
Example
SELECT 'Ths s js a Ts' AS ISCORRECT, F_STRIPSTRING('This is just a Test', 'ieut') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRIPSTRING ============= =============================================================================== Ths s js a Ts Ths s js a Ts
Example
SELECT NULL AS ISCORRECT, F_STRIPSTRING(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRIPSTRING ========= =============================================================================== <null> <null>
back to top of page
<< F_REVERSE U_REVERSE | IBExpert UDF Functions | F_STRIPSTRINGHOLD F_HOLDSTRING F_BIGSTRIPSTRINGHOLD U_STRIPSTRINGHOLD >>
