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 …
1
vote
1 answer

Convert a list of hierachical strings to JSON in C#

I have a list of strings that represent hierarchical data and are hyphen-separated (3 hyphens denote separation). I'm trying to convert this list into a JSON string so that I can bind it to a tree control. I am looking for a C# example. The list…
TheRedDwarf
  • 183
  • 1
  • 13
1
vote
2 answers

Convert tab delimited to XTS within R?

I have tab delimited file in format of: Date Time Last LastSize TotVol Bid Ask TickID BidSize AskSize 8/23/2012 0:00:00 0.95711 1 20670 0.95711 0.95742 0 0 0 8/23/2012 0:00:04 0.9571 1 20671 0.9571 0.9574 0 0 …
heavy rocker dude
  • 2,271
  • 8
  • 33
  • 47
1
vote
2 answers

VB.Net editing a CSV (or delimited file)

I would like to know a way (of course I want to know the best way) to edit a csv file, preferably without having to read the original and write the results to a new one. Example 1: I want to split the contents of a column into two columns 123abc…
donbyte
  • 253
  • 2
  • 6
  • 13
0
votes
2 answers

rijndael encryption

does this encryption library use pipe characters? I'm storing the key in an array with the corresponding UserID value, and delimiting them with a pipe character. If the library generates keys with pipe characters, those keys will get mangled when…
nraab
0
votes
2 answers

Parsing single CSV column delimited by ~HEADER@

I have a CSV file which needs some additional processing. I've got most of our custom functionality completed. My stuck at the moment is the latest addition to the feed, multiple categories in 1 column. Here is a quick example of the new field…
0
votes
1 answer

SQL query for delimited string

I have string column in a table, its length can be different and delimited by /, examples below. I am trying to remove any last characters after last / sign, including last / sign. Any ideas would be appreciated, I haves tried left, charindex, etc…
0
votes
0 answers

MaterialUI TextField not resizing properly when pasting delimited list of emails

I have a form to create users, and the user can paste a delimited list of email addresses into a TextField, where they are turned into Chips. const MultiUserAdd = () => { const [emails, setEmails] = useState([]); const…
Mike Nito
  • 11
  • 1