F_STRINGLISTITEM

<< F_STRINGLENGTH(..4, ..8, ..32) F_BIGSTRINGLENGTH U_STRINGLENGTH | IBExpert UDF Functions | F_WORDCOUNT >>

F_STRINGLISTITEM

 
  • compatibility to GrUDF
  • Compatible with UTF-8
  • Input VARCHAR(32760) stringlist formatted like ”n=..”,”m=..”, a.s.o., VARCHAR(254) Value from the list to be shown
  • Output VARCHAR(1024) Searchs the string, build a stringlist (Name=Value) for the Name and returns the complete Name=Value

Example

 SELECT '2=yellow' AS ISCORRECT, F_STRINGLISTITEM('"1=blue","2=yellow","3=green","4=red"', '2') FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_STRINGLISTITEM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
 ========= ===============================================================================
 2=yellow  2=yellow 

Example

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

Expected results:

 ISCORRECT F_STRINGLISTITEM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
 ========= ===============================================================================
 <null>    <null>                  

back to top of page
<< F_STRINGLENGTH(..4, ..8, ..32) F_BIGSTRINGLENGTH U_STRINGLENGTH | IBExpert UDF Functions | F_WORDCOUNT >>