F_REPEATTRIM
<< F_STRIPSTRINGHOLD F_HOLDSTRING F_BIGSTRIPSTRINGHOLD U_STRIPSTRINGHOLD | IBExpert UDF Functions | F_STRREPEAT >>
F_REPEATTRIM
* input/output-compatibility to rFunc (REPEATTRIM, LONGREPEATTRIM)
U_REPEATTRIM
- function from adhoc
- Compatible with UTF-8
- Input VARCHAR(8190) String 1 from which characters will be removed, VARCHAR(1) character to remove
- Output VARCHAR(8190) String with removed all repeatings of characters parameter 2
Example
SELECT '123' AS ISCORRECT, F_REPEATTRIM('12223', '2') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_REPEATTRIM ========= =============================================================================== 123 123
Example
SELECT NULL AS ISCORRECT, F_REPEATTRIM(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_REPEATTRIM ========= =============================================================================== <null> <null>
back to top of page
<< F_STRIPSTRINGHOLD F_HOLDSTRING F_BIGSTRIPSTRINGHOLD U_STRIPSTRINGHOLD | IBExpert UDF Functions | F_STRREPEAT >>
