F_FINDNTHWORD
<< F_WORDNUM | IBExpert UDF Functions | F_FINDWORDINDEX >>
F_FINDNTHWORD
- compatibility to FreeUDFLib, FreeUDFLib AvERP
- Compatible with UTF-8
- Input VARCHAR(32760) string, in which an other string is looked for, INTEGER no. of string to find (n-ths word)
- Output VARCHAR(254) nth-word
Counting starts at 0.
Example
SELECT 'ABC' AS ISCORRECT, F_FINDNTHWORD('ABC 123 45678 9123', 0) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_FINDNTHWORD ========= =============================================================================== ABC ABC
Example
SELECT '123' AS ISCORRECT, F_FINDNTHWORD('ABC 123 45678 9123', 1) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_FINDNTHWORD ========= =============================================================================== 123 123
Example
SELECT '' AS ISCORRECT, F_FINDNTHWORD('ABC 123 45678 9123', 5) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_FINDNTHWORD ========= ===============================================================================
Example
SELECT NULL AS ISCORRECT, F_FINDNTHWORD(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_FINDNTHWORD ========= =============================================================================== <null> <null>
back to top of page
<< F_WORDNUM | IBExpert UDF Functions | F_FINDWORDINDEX >>
