The following works invoke it as select * from table(splitter(‘a,b,c,d’)) create or replace function splitter(p_str in varchar2) return sys.odcivarchar2list is v_tab sys.odcivarchar2list:=new sys.odcivarchar2list(); begin with cte as (select level ind from dual connect by level <=regexp_count(p_str,’,’) +1 ) select regexp_substr(p_str,'[^,]+’,1,ind) bulk collect into v_tab from cte; return v_tab; end; /
#include <iostream> #include <sstream> std::string input = “abc,def,ghi”; std::istringstream ss(input); std::string token; while(std::getline(ss, token, ‘,’)) { std::cout << token << ‘\n’; } abc def ghi
Found answer here: NSString *string = @”oop:ack:bork:greeble:ponies”; NSArray *chunks = [string componentsSeparatedByString: @”:”];
There is apex_util.string_to_table – see my answer to this question. Also, prior to the existence of the above function, I once posted a solution here on my blog. Update In later versions of APEX, apex_util.string_to_table is deprecated, and a similar function apex_string.split is preferred.
You can use the std::string::find() function to find the position of your string delimiter, then use std::string::substr() to get a token. Example: std::string s = “scott>=tiger”; std::string delimiter = “>=”; std::string token = s.substr(0, s.find(delimiter)); // token is “scott” The find(const string& str, size_t pos = 0) function returns the position of the first occurrence … Read more
I use a for loop to iterate the string and use charAt() to get each character to examine it. Since the String is implemented with an array, the charAt() method is a constant time operation. String s = “…stuff…”; for (int i = 0; i < s.length(); i++){ char c = s.charAt(i); //Process char } … Read more
They’re essentially horses for courses. Scanner is designed for cases where you need to parse a string, pulling out data of different types. It’s very flexible, but arguably doesn’t give you the simplest API for simply getting an array of strings delimited by a particular expression. String.split() and Pattern.split() give you an easy syntax for … Read more
This may be an improved way (also with regexp and connect by): with temp as ( select 108 Name, ‘test’ Project, ‘Err1, Err2, Err3’ Error from dual union all select 109, ‘test2’, ‘Err1’ from dual ) select distinct t.name, t.project, trim(regexp_substr(t.error, ‘[^,]+’, 1, levels.column_value)) as error from temp t, table(cast(multiset(select level from dual connect by … Read more
How do I tokenize a string in C++?
You can use String‘s methods replaceAll and split together here. String one = “show ip interface brief | include 1234**\n Gi1/23.1234 xxx.225.xxx.106 YES manual up up”; String[] tokens = one.replaceAll(“[^\\n]+\\n\\s*”, “”).split(“\\s+”); System.out.println(Arrays.toString(tokens)); Output [Gi1/23.1234, xxx.225.xxx.106, YES, manual, up, up]