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 >>
