F_

<< F_PADCENTER U_PADCENTER | IBExpert UDF Functions | F_REPLACE (F_REPLACE4, F_REPLACE8) F_BIGREPLACE >>

F_LINEWRAP

 
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

U_LINEWRAP

  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(32760) String, INTEGER starting position, INTEGER measure
  • Output VARCHAR(32760)Spends all words of the string, begin with the initial position, which are all not longer than the measure.

Counting starts with 0.

Example

 SELECT  'like to drive fast' AS ISCORRECT, F_LINEWRAP('John like to drive fast', 5, 22) FROM RDB$DATABASE;

Expected results:

 ISCORRECT          F_LINEWRAP                                                                                                                                                                                                                   
 ==================  ===========================================================
 like to drive fast like to drive fast 

Example

 SELECT  'like to drive' AS ISCORRECT, F_LINEWRAP('John like to drive fast', 5, 17) FROM RDB$DATABASE;

Expected results:

 ISCORRECT     F_LINEWRAP                                                                                                                                                                                                                        
 ============= ===========================================================
 like to drive like to drive  

Example

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

Expected results:

 ISCORRECT F_LINEWRAP                                                                                                                                                                                                                            
 ========= ===============================================================
 <null>    <null> 

back to top of page
<< F_PADCENTER U_PADCENTER | IBExpert UDF Functions | F_REPLACE (F_REPLACE4, F_REPLACE8) F_BIGREPLACE >>