meta data for this page
  •  

F_STRIPSTRINGHOLD, F_HOLDSTRING, F_BIGSTRIPSTRINGHOLD

compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF

compatibility to FreeUDFLibC

Entrypoint stripstringhold not compatible with UTF-8 - use U_STRIPSTRINGHOLD

U_STRIPSTRINGHOLD

function from adhoc

Entrypoint u_stripstringhold compatible with UTF-8

Inputs/Outputs

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

Syntax

   The sequence of the indications in the string 2 does not matter.
   Counterpart to F_STRIPSTRING
   Note:
   In a SQL F_HOLDSTRING and F_STRIPSTRINGHOLD may not use at the same time.
   TestSQL
   SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'iet') FROM RDB$DATABASE;
   SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'tei') FROM RDB$DATABASE;
   SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'iet') FROM RDB$DATABASE;
   SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'tei') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRIPSTRINGHOLD(NULL, NULL) FROM RDB$DATABASE;