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 >>