Convert Comma Separated column value to rows

try this SELECT A.[id], Split.a.value(‘.’, ‘VARCHAR(100)’) AS String FROM (SELECT [id], CAST (‘<M>’ + REPLACE([string], ‘,’, ‘</M><M>’) + ‘</M>’ AS XML) AS String FROM TableA) AS A CROSS APPLY String.nodes (‘/M’) AS Split(a); refer here Converting a single comma separated row into multiple rows

Split function in oracle to comma separated values with automatic sequence

Here is how you could create such a table: SELECT LEVEL AS id, REGEXP_SUBSTR(‘A,B,C,D’, ‘[^,]+’, 1, LEVEL) AS data FROM dual CONNECT BY REGEXP_SUBSTR(‘A,B,C,D’, ‘[^,]+’, 1, LEVEL) IS NOT NULL; With a little bit of tweaking (i.e., replacing the , in [^,] with a variable) you could write such a function to return a table.

How to use delimiter for CSV in Python?

Your code is blanking out your file: import csv workingdir = “C:\Mer\Ven\sample” csvfile = workingdir+”\test3.csv” f=open(csvfile,’wb’) # opens file for writing (erases contents) csv.writer(f, delimiter=” “,quotechar=”,”,quoting=csv.QUOTE_MINIMAL) if you want to read the file in, you will need to use csv.reader and open the file for reading. import csv workingdir = “C:\Mer\Ven\sample” csvfile = workingdir+”\test3.csv” f=open(csvfile,’rb’) … Read more

When to use the terms “delimiter,” “terminator,” and “separator”

A delimiter denotes the limits of something, where it starts and where it ends. For example: “this is a string” has two delimiters, both of which happen to be the double-quote character. The delimiters indicate what’s part of the thing, and what is not. A separator distinguishes two things in a sequence: one, two 1\t2 … Read more

Split a string into words by multiple delimiters [duplicate]

Assuming one of the delimiters is newline, the following reads the line and further splits it by the delimiters. For this example I’ve chosen the delimiters space, apostrophe, and semi-colon. std::stringstream stringStream(inputString); std::string line; while(std::getline(stringStream, line)) { std::size_t prev = 0, pos; while ((pos = line.find_first_of(” ‘;”, prev)) != std::string::npos) { if (pos > prev) … Read more