RON70 <ron_michael70 <at> yahoo.com> writes:
>
> - <Temp diffgr:id="Temp14" msdata:rowOrder="13">
> <Date>2005-01-17T00:00:00+05:30</Date>
> <SecurityID>10149</SecurityID>
> <PriceClose>1288.40002</PriceClose>
> </Temp>
....
Looks suspiciously like XML, and let's hope the real data are more like this
below, without the "-" and with a nice header
<?xml version="1.0" encoding="utf-8"?>
<temps>
<Temp diffgr:id="Temp14" msdata:rowOrder="13">
<Date>2005-01-17T00:00:00+05:30</Date>
<SecurityID>10149</SecurityID>
<PriceClose>1288.40002</PriceClose>
</Temp>
<Temp diffgr:id="Temp15" msdata:rowOrder="14">
<Date>2005-01-18T00:00:00+05:30</Date>
<SecurityID>10149</SecurityID>
<PriceClose>1291.69995</PriceClose>
</Temp>
<Temp diffgr:id="Temp16" msdata:rowOrder="15">
<Date>2005-01-19T00:00:00+05:30</Date>
<SecurityID>10149</SecurityID>
<PriceClose>1288.19995</PriceClose>
</Temp>
</temps>
The following code should give you a starter; some massaging of the Dates
required. There are warnings because of the missing prefixes diffgr and msdata.
For a first attempt, you can ignore these, but better get the full data set.
library(XML)
doc = xmlInternalTreeParse("temp.xml")
Date = sapply(getNodeSet(doc, "//Date"), xmlValue)
SecurityID = as.integer(sapply(getNodeSet(doc, "//SecurityID"), xmlValue))
Dieter
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
