Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
3
votes
3 answers

Process a line of delimited numbers in bash

I have a line of numbers, and I want to be able to process them one by one. For ex. 3829 4837 3729 2874 3827 I want to be able to get the sum, largest number, anything. But I'm not sure how to get each number to process it. I would…
Khadijah Celestine
  • 505
  • 7
  • 19
3
votes
1 answer

R programming transfering data from excel with missing values to R

So I have an excel spreadsheet with NA values....What is the best way to copy the data and put it in R...I usually use data=read.delim("clipboard").... But because of those missing values....I keep getting this error Error in if (del == 0 && to ==…
Marco De Niro
  • 27
  • 7
3
votes
3 answers

How to parse a delimited list with image urls using XSL?

I have a list containing urls for images that I would like to parse and display using XSL but I only want the first 3 images. e.g. Returns: ['http://www.test.com/image1.jpg', 'http://www.test.com/image2.jpg', …
Rsquare
  • 81
  • 5
2
votes
1 answer

Check if json tree doesn't have more children

my question relates to Convert delimited string into hierarchical JSON with JQuery I have a similar task where I have to create a json object from a delimited string as: var input = ["Fred-Jim-Bob", "Fred-Jim", "Fred-Thomas-Rob", "Fred"]; which…
mvovchak
  • 291
  • 5
  • 13
2
votes
3 answers

regex to match word separated by characters and enclosed by xml tags

I have been trying to build a regex to do the following: Look for the word "alphabet" enclosed in xml tags , search would match the following: Al"pha*bet Al"pha*be`t alphabet al*pha*bet …
Alex
  • 2,247
  • 1
  • 27
  • 37
2
votes
3 answers

Difference between two unordered delimited strings in PL/SQL

Is there a simple elegant method to return the difference between two unordered, delimited strings in Oracle using PL/SQL? Example: String A: "a1, b4, g3, h6, t8, a0" String B: "b4, h6, a0, t8, a1" Difference: "g3" I don't have access to APEX_UTIL…
user813345
  • 23
  • 4
2
votes
3 answers

How to read parts of a delimited file

I have a file that looks like this: 1028806~HDR~20110815~15-AUG-2011~C~23:10~~~~~~~ 1028806~DTL~C3914A~HWP-C3914A~1000949~A~LASERJET MAINT KIT 8100/N/DN~HEWLETT…
Mankind1023
  • 7,198
  • 16
  • 56
  • 86
2
votes
4 answers

Split lines of space-delimited values to get flat array of 2nd and 3rd column values

I have the following data which is displaying as this {123456 123456 123456} {654321 654321 654321} {123456 123456 123456} My PHP Code: $myarray = preg_split("/(\s|{\s)/", $data); print_r($myarray); The output of my array is like this: [0]…
thebest man
  • 109
  • 5
2
votes
3 answers

Split string with only one delimiting character into key-value pairs

I have a colon-delimited string like this: "Part1:Part2:Part3:Part4" With explode I can split the string into an array: echo '
';
print_r(explode(":", "Part1:Part2:Part3:Part4"));
echo '
'; Output: Array ( [0] => Part1 [1] =>…
Trombone0904
  • 4,132
  • 8
  • 51
  • 104
2
votes
1 answer

Select values from table where value in comma delimited string

this is my first post... I'm busy writing up a piece of software in Access 2010. My SQL's not too bad, but I'm a little stumped here. I have a table with the following layout ID = AutoNumber, Category = Text, SubCategory = Text, Grades =…
Warren Boone
  • 23
  • 3
2
votes
3 answers

Split a string with two delimiters into two arrays (explode twice)

How can I split this string of comma-separated dimensions into two arrays? The string may have many items in it, but it will always have the same two alternating delimiters (exes and commas). $str = "20x9999,24x65,40x5"; I need to get two arrays…
ohgodpleasehelpme
  • 65
  • 5
2
votes
1 answer

XSLT: How to separate deliminated values into unique elements

I'm working in a database that doesn't really support subelements. To get around this, we've been using squiggly brackets }} in a string of values to indicate separations between subelements. When we export to xml, it looks something like…
s. nakasone
  • 21
  • 1
2
votes
1 answer

SSIS flat file with values containing text qualifier

I received a flat file that cannot be generated in other way. The delimited is a comma and the text qualifier is a double quote. The problem is that sometimes a have a double quote in the value. In example: "0","12345", "Centre d"edu et de…
Bradford1138
  • 65
  • 1
  • 1
  • 7
2
votes
2 answers

Changing a pipe delimited file to comma delimited in VB.net

So I have a set of pipe delimited inputs which are something like this: "787291 | 3224325523" | 37826427 | 2482472 | "46284729|46246" | 24682 | 82524 | 6846419 | 68247 and I am converting them to comma delimited using the code given below: Dim…
Abhijeet Singh
  • 23
  • 7
2
votes
3 answers

Switch placement of values in comma delimited string

I have a comma delimited string held within a database field that could contain any number of values: 23,45,21,40,67,22 I need to be able to somehow switch two values, so for example I know I need to move 45 one position down the string, so I end…
Paul
  • 661
  • 4
  • 12
  • 22
1 2
3
…
14 15