Add function oos_util_string.strtok

[jeffreykemp]

Tokenize a string. Similar in functionality to strtok from C and PHP.

Useful in procedural code when the delimiter character(s) can change from token to token - i.e. not a fixed set of delimiters for the whole string.

I'll update with a simple implementation.

[alexys009]

Hi, Jeff. I have a pipelined function (in my lib package) I am using for many years. It can be used in sql or pl/sql. Here its interface function str2tbl (p_str clob, p_delimiter varchar2:= ',|;.', p_encloser varchar2:='"', p_low varchar2 := 'y' , p_split number:=0, p_char varchar2:=chr(1)) return str_arr pipelined;

It seems that it does what you are looking for, although not exactly C or PHP tokenizer. If you are interested I can submit function code.

Regards, Alex

[jeffreykemp]

Hi Alex, that's nice and might make a good addition to this package, but it's not a like-for-like replacement for strtok.

strtok is called once per token, and you can give a different delimiter (or set of delimiters) for each token.