Parsing Yahoo quote server returns

[Brent]

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/quotes.csv?s=XOM&f=sl1d1t1c1ohgvf6&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

 

[Nicholas Paldino [.NET/C# MVP]]

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.