473,320 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Parsing Yahoo quote server returns

Anyone have an idea how I might parse a "CSV" list from Yahoo, when
the numbers themselves include commas?

For example, this link ...

http://download.finance.yahoo.com/d/...1ohgvf6&e=.csv

....returns something like...

"XOM",82.08,"8/3/2007","4:12pm",-3.10,84.62,85.88,81.53,36197468,
5,538,790,000

.... in which the number 5,538,790,000 ...

should (in theory) have no commas, as it is a single value.

Thanks for any help.

--Brent

Aug 4 '07 #1
1 2009
Brent,

In this case, the numbers should be wrapped with quotes to indicate a
single value. If it is not, then the only way I can think of this working
would be if you knew the schema, so that you know how to group the numbers
correctly. The only way I can think of that you will be able to handle this
is if the value that you need is the last one on the sheet, and you know how
many columns come before it.

This is really an error on the part of yahoo, to be honest. I'd make
them aware of it to see if they can fix it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Brent" <wr********@gmail.comwrote in message
news:11*********************@z24g2000prh.googlegro ups.com...
Anyone have an idea how I might parse a "CSV" list from Yahoo, when
the numbers themselves include commas?

For example, this link ...

http://download.finance.yahoo.com/d/...1ohgvf6&e=.csv

...returns something like...

"XOM",82.08,"8/3/2007","4:12pm",-3.10,84.62,85.88,81.53,36197468,
5,538,790,000

... in which the number 5,538,790,000 ...

should (in theory) have no commas, as it is a single value.

Thanks for any help.

--Brent
Aug 5 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Gerrit Holl | last post by:
Posted with permission from the author. I have some comments on this PEP, see the (coming) followup to this message. PEP: 321 Title: Date/Time Parsing and Formatting Version: $Revision: 1.3 $...
2
by: Rashida | last post by:
Hi all! I have written a function to fetch lebels from xml file for cross-language interoperability. Please refer function code below. I am invoking itfrom my asp page saying...
2
by: James D. Marshall | last post by:
One question on parsing, the line has double carriage returns that show up as squares, I am seeing this through watch1, how would you code a replace statement to get rid of these, its driving me...
7
by: Mahesh Devjibhai Dhola | last post by:
Hi, I want to develop p2p (peer-to-peer) communication connection for chat in ..Net (Lang: c# - preferable) NOTE: if two LAN are behind their own router then also it should work as yahoo, msn...
6
by: bwaichu | last post by:
I am writing a very basic web server, and I need to parse the HTTP Request string that I am receiving. Are there any good C books that suggest ways to parse strings effectively? Thanks!
3
by: sollento | last post by:
Hello, I am writing an asp.net application to retrieve a cvs file from an http request and populate a dataset. Can someone provide sample code or a reference example. Step 1: http request to...
13
by: Chris Carlen | last post by:
Hi: Having completed enough serial driver code for a TMS320F2812 microcontroller to talk to a terminal, I am now trying different approaches to command interpretation. I have a very simple...
5
by: PatlaDJ | last post by:
Java SAX parser, please need a clue how to get the raw XML code of the currently parsing event... needed for logging, debugging purposes. Here's and example, letting me clarify exactly what i...
3
by: raghudr | last post by:
Hi all, I am parsing a .xml file.My main intention is to retrieve the name value of node "Signal":- "Name Value" which is "rag". i want to store only the <signal"name value" that is only...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.