F_WORDNUM

<< F_FINDWORD U_FINDWORD | IBExpert UDF Functions | F_FINDNTHWORD >>

F_WORDNUM
  • input/output-compatibility to rFunc (WORDNUM, LONGWORDNUM)
  • Input VARCHAR(32760) string, in which an other string is looked for, INTEGER no. of string to find (n-ths word), VARCHAR(31) word delimiter, SMALLINT ???
  • Output VARCHAR(254) nth-word

Counting for parameter 2 starts with 1.

Example 

 SELECT 'ABC' AS ISORRECT, F_WORDNUM('ABC 123 45678 9123', 1, ' ', 0) FROM RDB$DATABASE;

Expected results: 

 ISORRECT F_WORDNUM                                                                                                                                                
 ======== ===============================================================================
 ABC      ABC

Example 

 SELECT NULL AS ISCORRECT, F_WORDNUM(NULL, NULL, NULL, NULL) FROM RDB$DATABASE;

Expected results: 

 ISCORRECT F_WORDNUM                                                                                                                                               
 ========= ===============================================================================
 <null>    <null>

back to top of page
<< F_FINDWORD U_FINDWORD | IBExpert UDF Functions | F_FINDNTHWORD >>