Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
1
vote
2 answers

$str = "1,2,3,4,5,6,7"; How to get the sum of values?

I was asked this question in a PHP test, Question: How to get the sum of values? $str = "1,2,3,4,5,6,7"; My Solution was: // Splitting numbers in array and adding them up $str = "1,2,3,4,5,6,7"; $num_array = explode(',', $str); $str =…
Aman
  • 13
  • 2
1
vote
2 answers

Delimited Semi-Colon Text in SQL with Accumulated Count

I have a table below Program FileCount B1 1 A1;B2 2 A2;B3 1 A3;C1;B4 1 A3;C2;D1;B5;B6 3 C3;D2;B7 1 B8;B9 2 B8;B9 2 I'm only interested in program B and I would…
Adhitya Sanusi
  • 119
  • 2
  • 17
1
vote
1 answer

Splitting multiple delimited values into multiple rows

I have been looking for a solution in StackOverflow but didn't find anything useful. I am facing a issue and I hope anyone would like to help me out. I have value like this: Create table DemoRecords ( CustID int identity (1,1), CustomerName…
Sajid Wasim
  • 71
  • 9
1
vote
1 answer

FileHelpers3 - recursive object

This object fills just fine [DelimitedRecord("|")] public class LvMenuItems { public string Sequence { get; set; } public string DisplayText { get; set; } public string MenuId { get; set; } public string PageUrl { get; set; } …
phigits
  • 85
  • 2
  • 7
1
vote
2 answers

SAS import txt file using infile

I am looking at two procedures to import two txt files in SAS. The first file is fixed width. The second txt file is delimited file. The SAS code attached below: DATA filename; INFILE "filelocation"; INPUT VAR1 $1-11 VAR2 $13-16 @18…
mumu.W
  • 53
  • 5
  • 11
1
vote
1 answer

Reading non delimited text file into R

I have a large set of Data that is in an non delimited format that I am trying to import into R. The data set comes with a Column Locations file that includes a row number, the column name, and the character position of the variable. Is there an…
frog11
  • 38
  • 1
  • 7
1
vote
1 answer

multi-array search query with delimited field

I have a array which store some country names im doing a search module and i wanna to find the db records whether contain the country names or not but since db design problem , those record can own mutil counties and store the countries by delimiter…
user192344
  • 1,274
  • 6
  • 22
  • 36
1
vote
2 answers

Breaking an XML string into three floats

I'm parsing XML data that contains string values, space delimited, that represent floating point values:

123.456 987.654 867.5309

345.766 234.132 654.4564

... For each of the P items I need to assign the three float…
D. Waschow
  • 121
  • 2
1
vote
1 answer

C# - Write to a datatable from delimited string

I have a string something like this: "X","Y","Z" "X2","Y2","Z2" i.e, Multiple rows seperated by a new line containing multiple different string values delimited by commas. How could I create a function to input these values into a datatable like…
ToppuKekku
  • 13
  • 1
  • 3
1
vote
2 answers

Importing a space delimited file into a DataGridView

I have the following data that I wish to import into a DataGridView: 01-29-15 04:04AM 505758360 examplefilename1.zip 01-28-15 12:28AM 501657000 this_is_another_file.zip 01-29-15 02:27AM 1629952132…
user863551
1
vote
1 answer

Delimiter Warning in shell Script with psql

I get a Delimter Error in a Shell Script: #!/bin/sh result=`psql -d databasename -t -A <
eof
  • 13
  • 4
1
vote
2 answers

Split comma delimited cell into columns

Soo ive found a lot of similar questions but nothing that really fits what im looking to do, and im a little bit stuck. Basically what im looking to do is have a cell (in this instance, A1), that has multiple values separated by commas (always 4…
user3779771
  • 13
  • 3
1
vote
3 answers

Adding ROW_NUMBER() to query loses DISTINCT, defeats the purpose of paged results attempt

I'm having a problem bringing back a truly DISTINCT set of records using ROW_NUMBER() with a LEFT JOIN whose joined results are in turn concatenated into a comma-delimited list with the FOR XML PATH trick. The objective is to implement paging in a…
Monica
  • 55
  • 1
  • 11
1
vote
1 answer

How to create a tab delimited in Eclipse Java

I'm trying to make my result looks good by having a good tab for each column result. Here's my toString() function. I searched for this problem in stackoverflow, but it doesn't answer my question. I can't find the StringUtils.rightPad(String, int)…
Frans Raharja Kurniawan
  • 965
  • 8
  • 21
1
vote
0 answers

PHP script to Import Tab Delimited data into a pre-made Mysql Database

I'm very new to PHP, with basic understanding. However I am in need of being able to pass data from a text file to a mysql database. The text file contains all the data I need, and it is all tab separated and on separate rows for separate entries,…
Vereonix
  • 1,341
  • 5
  • 27
  • 54
1 2 3
…
14 15