F_RWORDCOUNT

<< F_WORDCOUNT | IBExpert UDF Functions | F_STRINGCOUNT F_RSTRINGCOUNT >>

F_RWORDCOUNT
  • input/output-compatibility to rFunc (WORDCOUNT)
  • Compatible with UTF-8
  • Input VARCHAR(32760) String, VARCHAR(31) word delimiter, SMALLINT
  • Output INTEGER number of words

Example 

 SELECT 4 AS ISCORRECT, F_RWORDCOUNT('ABC 123 45678 9123', ' ', 0) FROM RDB$DATABASE;

Expected results: 

    ISCORRECT F_RWORDCOUNT
 ============ ============
            4            4

Example 

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

Expected results: 

 ISCORRECT F_RWORDCOUNT
 ========= ============
 <null>          <null>

back to top of page
<< F_WORDCOUNT | IBExpert UDF Functions | F_STRINGCOUNT F_RSTRINGCOUNT >>