Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
0
votes
1 answer

How do I make a string array based on a text file with newline delimited entries in C#?

Possible Duplicate: C# how to convert File.ReadLines into string array? I have a text file that I want to make a String array from. The file is newline delimited. For example, entry1 entry2 entry3 will make an array of {"entry1", "entry2",…
Zachster1996
  • 21
  • 2
0
votes
4 answers

Convert array of delimited strings to variables

I need to convert all items in array to variables like: $item[0] = "apple=5"; $item[1] = "banana=7"; $item[2] = "orange=8"; And I want to convert it to this: $apple = 5; $banana = 7; $orange = 8; Like normal variables. Is it possible?
Marek Schubert
  • 107
  • 1
  • 2
  • 10
0
votes
4 answers

PHP Counting delimited values in text file that are all on the same line

I need a script to count the number of pipe delmited entries in a text file that are all on one line. I found a script that counts lines and modified it thinking I might get it to work but sadly it still counts the lines, so at present putputs the…
Martyn
  • 73
  • 1
  • 3
  • 14
0
votes
2 answers

Getting a certain substring between two different delimiters based on a certain condition in java

So I am not really familiar with the java String methods and I am not sure if there's an easy way to do this. I have a String which contains couple of values delimited with ":" and each couple is separated from the others by another delimiter ",".…
wassim
  • 277
  • 1
  • 6
  • 22
0
votes
1 answer

get SQL to work with a select form element, comma delimited

I'm trying to allow users to view only certain records, where query variables are given by the user using a form. The form contains a datepicker and 3 select-elements where users can select multiple options, the allowed options are populated by SQL…
Geoffrey Bergman
  • 13
  • 2
0
votes
3 answers

delimited txt file to array? then update mysql PHP

How'd I go about reading a tab delimited .txt file and then coding it so it puts each column of data(that is seperated with a tab) into a php variable. for example.... 505050 somedata moredata and then, writing these variables…
fyllepo
  • 1,944
  • 2
  • 13
  • 16
-1
votes
1 answer

Remove items in a delimited list that are non numeric in SQL for Redshift

I am working with a field called codes that is a delimited list of values, separated by commas. Within each item there is a title ending in a colon and then a code number following the colon. I want a list of only the code numbers after each…
MJ B
  • 19
  • 4
-1
votes
1 answer

How to build a delimited string using column names if the field is empty?

I did some searching, and most returned the table names or was a bit over-kill for my needs (replacing data..if higher/lower..etc) I have an existing table I need to work with: id | booth_100 | booth_101 | booth_102 | booth_103 | booth_105 |…
whispers
  • 962
  • 1
  • 22
  • 48
-1
votes
1 answer

How to convert Excel workbook to text (tab delimited)?

I follow the instruction for converting Excel workbook to text (tab delimited), so it can be readable by R. However it does not work. The output are saved as text (tab delimited) when I check the properties. But when I open the file, nothing has…
Maryam Zanjirband
  • 1
  • 2
-1
votes
1 answer

Delimit output created using a grep command

I want to run a line of code to create a Text to columns output on a file which is comma delimited. I have created a file which results in the output been created in the format comma delimited. So all the data is in column A separated by a ,. The…
Stephen
  • 47
  • 1
  • 11
-1
votes
2 answers

Delimited txt into an array with keys provided by first cell of delimieted txt

ID OID Title Description Option Price 01 01JAP Japanese Model Japanese Model of the Dave Smith Japanese "$3,000 " 02 02ENG English Model English Model of the dave Smith english "$1,000 " The txt file, example shown above is…
n0rad
  • 82
  • 9
-1
votes
7 answers

Merge data into an array then count the array values

I need to merge data into an array, then count the array values. $str = '"Cat","A","A","A","A"'; $abc = [ $str, "A", "Cat", "Dog", "A", "Dog" ]; print_r(array_count_values($abc)); Result came out: Array (…
Ashish
  • 7
  • 2
-1
votes
2 answers

mySQL >> Normalizing a comma-delimited field

I currently have a table called "RESOURCES" with a keywords field called "RES_Tags". The "RES_Tags" field contains a comma-delimited list of keywords for each record. I need to normalize this table/field. I have already set up the following tables:…
nbardach
  • 123
  • 1
  • 10
-1
votes
2 answers

How do I convert data in this format to a table?

I have data that is in a big text file that looks like this: {"id": 111, "role": "manager", "name": "John doe"} with every "row" of info separated by swirly brackets. How do I get this to be a table in excel? Thanks in advance!
user7607346
  • 1
  • 1
-1
votes
1 answer

Delimited file to SQL via SSIS

I am trying to upload data to a sql server database table from a delimited file via a SSIS package but its throwing error The value could not be converted because of a potential loss of data These SSIS packages have been recently moved from…
arvind
  • 11
  • 1
1 2 3
…
14
15