Click to See Complete Forum and Search --> : problem splitting string


radujit
10-24-2010, 04:15 AM
Let me tell you what I want to do: get external information from yahoo in csv format and then save it to my local.



Dim objXmlHttptemp
Dim strHTMLtemp

Set objXmlHttptemp = Server.CreateObject("Msxml2.ServerXMLHTTP")

sql="http://ichart.finance.yahoo.com/table.csv?s=%5EGSPC&d=9&e=24&f=2010&g=d&a=0&b=3&c=2005"

objXmlHttptemp.open "GET", sql , False

objXmlHttptemp.send

strHTMLtemp = objXmlHttptemp.responseText




as you may see at the address
http://www.iisconsult.ro/down.asp

the data is downloaded

Now my problem is when I want to split the HTML on blanks

I use split(strHTMLtemp," ") but nothing happens

Can you help me

yamaharuss
10-27-2010, 02:28 PM
how are you using the split feature? Once you split it, you are creating an array that you must parse.