Questions tagged [delimited]
221 questions
1
vote
1 answer
"Connect By" to generate rows from multiple delimited string
we can use "Connect By" to generate rows from a delimited string in oracle. like:
SELECT Rn ,Regexp_Substr(data, '[^,]+', 1, LEVEL) Data
FROM (SELECT 1 Rn ,'id:a,val:b,desc:c' data FROM Dual) Idata
CONNECT BY Regexp_Substr(data, '[^,]+', 1, LEVEL)…

Plymouth Rock
- 472
- 2
- 6
- 20
1
vote
2 answers
Python list operation (append multiple lists)
I have a text file called test.txt which contains data in this format
....
a|b|c|d|e
a1|b2|c3|d4|e5
a3|b5|c2|d1|e3
....
I want to get the values of each column into lists: something like this
list1=[a,a1,a3]
list2=[b,b2,b5]
I managed to get this…

Chris Aung
- 9,152
- 33
- 82
- 127
1
vote
3 answers
Split an underscore-delimited string, but ignore underscores occurring in a url
Below string I need to split. I tried with the explode(), but it is fragmenting the url substring.
$link = "7_5_7_http://test.com/folder/images/7_newim/5_car/7_february2013/p/a00/p01/video-1.mov_00:00:09";
$ex_link = explode('_',$link);
It is…

Anish
- 4,262
- 6
- 36
- 58
1
vote
1 answer
How do I remove crlf in IE between string in text box
I have a simple text box. And for debugging purpose I have a submit button. Now when I write something in text box and click submit button I am printing content of the text box and its all fine. But when I copy the text from excel document it works…

mysteriousboy
- 159
- 1
- 7
- 20
1
vote
6 answers
Group rows of a multidimensional array and form comma-separated values within each group
I want to combine arrays having same category id and question id.
Sample input:
$array = [
[
'category_id' => 1,
'question_id' => 1,
'option_id' => 2,
'title' => 'Do you wear glasses?',
'answer' => 'no'
…

FrancisMV123
- 3,419
- 4
- 20
- 20
1
vote
3 answers
Parse string with three-level delimitation into dictionary
I've found how to split a delimited string into key:value pairs in a dictionary elsewhere, but I have an incoming string that also includes two parameters that amount to dictionaries themselves: parameters with one or three key:value pairs…

Jacob Stevens
- 854
- 1
- 8
- 17
1
vote
2 answers
Upload tab delimited txt file using form, then make into PHP arrays?
I'm trying parse a tab delemited text file into a set of PHP arrays, and help would be very much appreciated.
The .txt wil look like this (tab delimited not spaces)
data1a data1b data1c data1d
data2a data2b data2c data2d
data3a data3b data3c…

J. Podolski
- 201
- 6
- 16
1
vote
4 answers
Delimited Filename Parsed into Table Row Data
I am attempting to convert variable width, pipe (|) delimited file names into table data.
E.g.
var1|var2|var3|var4|var5.pdf
becomes