meta data for this page
  •  

F_BLOBSUBSTR

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (B_STRPOS)

Entrypoint blobsubstr not compatible with UTF-8 - use U_BLOBSUBSTR

U_BLOBSUBSTR

function from adhoc

Entrypoint u_blobsubstr compatible with UTF-8

Inputs/Outputs

   Input     BLOB              TextBLOb (in which you are looking for the string from parameter 2)
             CSTRING(1024)     String (you are looking for in the BLOb)
   Output    INTEGER           position in the BLOb where the string starts

Syntax

   Counting starts with 0.
   TestSQL (to use with TestISO.GDB)
   SELECT 4 AS ISCORRECT, F_BLOBSUBSTR(TEXTBLOB, 'einzeiliger') FROM BLOBTEST WHERE BLOBTESTID = 1;
   SELECT NULL AS ISCORRECT, F_BLOBSUBSTR(TEXTBLOB, NULL) FROM BLOBTEST WHERE BLOBTESTID = 10;