summary: provive functions to parse string with delimeters => Provide functions to parse delimited strings

Version: 2.5.0 [ 10221 ] =>

description: It's often need to parse some string with known delimeters and obtain:
1) count of tokens inside input string
2) get token by it's name.
Examples:

str = 'aaa,,,....,,bbb,;.;'';;ccc''', delimeters = '.;:,' || asci_char(39)
count of tokens ==> 3
token #⁠1 ==> 'aaa'
token #⁠2 ==> 'bbb'
token #⁠3 ==> 'ccc'

Is it possible to provide in FB 2.5.x two functions that can returns such results ? Currently developer have to use UDFs or SP with loop (i.e. cursor) or recursive CTE to get such simple data.

=>

It's often need to parse some string with known delimeters and obtain:
1) count of tokens inside input string
2) get token by it's number.
Examples:

str = 'aaa,,,....,,bbb,;.;'';;ccc''', delimeters = '.;:,' || asci_char(39)
count of tokens ==> 3
token #⁠1 ==> 'aaa'
token #⁠2 ==> 'bbb'
token #⁠3 ==> 'ccc'

So, the function calls could be like these:

select token_count(:str), token_get(:str, 2)
from rdb$database; -- returns 3 in 1st column and 'bbb' in 2nd

Is it possible to provide in FB 2.5.x two functions that can returns such results ? Currently developer have to use UDFs or SP with loop (i.e. cursor) or recursive CTE to get such simple data.