meta data for this page
  •  

F_STRIPSTRING, F_BIGSTIPSTRING

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

Entrypoint stripstring not compatible with UTF-8 - use U_STRIPSTRING

U_STRIPSTRING

function from adhoc

Entrypoint u_stripstring compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(32760)     String 1
             CSTRING(254)       String 2  as a list of all characters which are to delete
   Output    CSTRING(32760)     String stripped from all characters which are content of parameter 2

Syntax

   Counterpart to F_STRIPSTRINGHOLD and F_HOLDSTRING
   TestSQL
   SELECT 'Ds s n Ts Tx' AS ISCORRECT, F_STRIPSTRING('Dies ist ein Test Text', 'iet') FROM RDB$DATABASE;
   SELECT 'Ds s n Ts Tx' AS ISCORRECT, F_STRIPSTRING('Dies ist ein Test Text', 'tei') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRIPSTRING(NULL, NULL) FROM RDB$DATABASE;