Dear Rxperts, I am back to favoRite! I would need your favoR, please! Is there a way to use read "format" arguments for "POSIXct" or "strptime" from the xml file without specifying format="..." in these functions? The format of data-time values are present in the xml file as shown below.
Please see below am example section of XML code: <?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html=" http://www.w3.org/TR/REC-html40";><Styles><Style ss:ID="s11"><NumberFormat ss:Format="yyyy/mm/dd\ hh:mm;@"/></Style><Style ss:ID="s21"><Font ss:Color="White" ss:Bold="1"/><Interior ss:Color="Black" ss:Pattern="Solid"/></Style><Style ss:ID="s31"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/></Borders></Style><Style ss:ID="s41"><Font ss:Size="20"/></Style><Style ss:ID="s12"><NumberFormat ss:Format="hh:mm:ss.000"/></Style></Styles><Worksheet ss:Name="Start"><Table ss:DefaultColumnWidth="80"><Row><Cell><Data ss:Type="String">ID</Data></Cell><Cell><Data ss:Type="String">1</Data></Cell></Row><Row><Cell><Data ss:Type="String">Start</Data></Cell><Cell ss:StyleID="s11">*<Data ss:Type="DateTime">2012-06-14T09:16:16.512</Data>*</Cell></Row></Table> </Worksheet></Workbook> On Fri, Jun 8, 2012 at 8:08 AM, Uwe Ligges <[email protected]>wrote: > > > On 06.06.2012 22:44, Santosh wrote: > >> Hello experts, >> >> Sorry for posting the SPlus related question here.. I have not found any >> solution yet after some attempts and hence, sending it to a wider spectrum >> of users! I was successful in processing files uing R's XML librariy. >> > > Not that we know, we just know about an R *package* called XML. > > > > Thank >> you, Rxperts! >> >> I know there are libraries like XML and SPXML available in S-Plus. Could >> anyone please share examples of reading an xml file and save the contents >> in a data frame? >> >> Are there Splus equivalents of "getNodeSet", "xmlSApply" and "xmlValue"? >> > > > Most of us do not have S-PLUS available to check (actually, we do have a > 13 year old copy S-PLUS 4.5 at our department). You do, obviously, hence > why not check it yourself? And if you can't, why not ask the vendor of your > statistics software? > > Best, > Uwe Ligges > > > >> Thanks so much! >> Santosh >> >> >> [[alternative HTML version deleted]] >> >> ______________________________**________________ >> [email protected] mailing list >> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help> >> PLEASE do read the posting guide http://www.R-project.org/** >> posting-guide.html <http://www.R-project.org/posting-guide.html> >> and provide commented, minimal, self-contained, reproducible code. >> > [[alternative HTML version deleted]] ______________________________________________ [email protected] 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.
