F_STRIPSTRINGHOLD
<< F_STRIPSTRING F_BIGSTRIPSTRING U_STRIPSTRING | IBExpert UDF Functions | F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM) U_REPEATTRIM >>
F_STRIPSTRINGHOLD
-
- compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF
F_HOLDSTRING
- compatibility to FreeUDFLibC
F_BIGSTRIPSTRINGHOLD
U_STRIPSTRINGHOLD
- function from adhoc
- Compatible with UTF-8
- Input VARCHAR(32760) String 1, VARCHAR(254) String 2 as a list of all characters which are not to delete
- Output VARCHAR(32760) String stripped from all characters which are not content of parameter 2
The sequence of the indications in the string 2 does not matter. Counterpart to F_STRIPSTRING Note: In a SQL F_HOLDSTRING and F_STRIPSTRINGHOLD may not use at the same time.
Example
SELECT 'iiutet' AS ISCORRECT, F_HOLDSTRING('This is just a Test', 'ieut') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_HOLDSTRING ========= =============================================================================== iiutet iiutet
Example
SELECT NULL AS ISCORRECT, F_STRIPSTRINGHOLD(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRIPSTRINGHOLD ========= =============================================================================== <null> <null>
back to top of page
<< F_STRIPSTRING F_BIGSTRIPSTRING U_STRIPSTRING | IBExpert UDF Functions | F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM) U_REPEATTRIM >>
