Re: [R] parsing the file

2016-08-28 Thread Jeff Newmiller
Based on the discussion of ORing values with characters in [1] which may generate "unusual" characters I suspect a botched conversion from EBCDIC may have messed with some of the data. If there are signed data fields then OP may need to read the original file and treat it as if it were binary

Re: [R] parsing the file

2016-08-28 Thread jim holtman
Here is an attempt at parsing the data. It is fixed field so the regular expression will extract the data. Some does not seem to make sense since it has curly brackets in the data. Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not

Re: [R] Parsing XML File

2015-10-13 Thread Lorenzo Isella
Dear Jim, Thanks for your reply. What you did is 100% what I need -- I now have a data frame with the relevant data and I can take up from there. Regards Lorenzo On Sun, Oct 11, 2015 at 03:54:10PM -0400, jim holtman wrote: Not sure exactly what you want since you did not show an expected

[R] Parsing XML File

2015-10-11 Thread Lorenzo Isella
Dear All, I am struggling with the parsing of the xml file you can find at https://www.dropbox.com/s/i4ld5qa26hwrhj7/account.xml?dl=0 Essentially, I would like to be able to convert it to a data.frame to manipulate it in R and detect all the attributes of an account for which unrealizedPNL

Re: [R] Parsing XML File

2015-10-11 Thread jim holtman
Not sure exactly what you want since you did not show an expected output, but this will extract the attributes from AccVal in the structure: > # > library(XML) > > xmlfile=xmlParse("/temp/account.xml") > > class(xmlfile)

Re: [R] Parsing XML file to data frame

2014-05-06 Thread starcraz
Tim - the file is a hyperlink at the beginning of the message called 'sample.xml' or here's the hyperlink http://r.789695.n4.nabble.com/file/n4689883/sample.xml -- View this message in context: http://r.789695.n4.nabble.com/Parsing-XML-file-to-data-frame-tp4689883p4690021.html Sent from the R

Re: [R] Parsing XML file to data frame

2014-05-06 Thread David Winsemius
On May 5, 2014, at 11:42 AM, Timothy W. Cook wrote: I didn't find an attached XML file. Maybe the list removes attachments? The list does not remove all attachments, It removes ones that are not among the listed acceptable formats. XML is not among the list of acceptable formats. If it had

Re: [R] Parsing XML file to data frame

2014-05-05 Thread Timothy W. Cook
I didn't find an attached XML file. Maybe the list removes attachments? You might try posting to StackOverflow.com if this is the case. On Fri, May 2, 2014 at 2:17 PM, starcraz chan_will...@email.com wrote: Hi all - I am trying to parse out the attached XML file into a data frame. The file

[R] Parsing XML file to data frame

2014-05-02 Thread starcraz
Hi all - I am trying to parse out the attached XML file into a data frame. The file is extracted from Hadoop File Services (HFS). I am new in using the XML package so need some help in parsing out the data. Below is some code that I explore to get the attribute into a data frame. Any help is

Re: [R] Parsing txt file

2010-11-10 Thread Santosh Srinivas
] On Behalf Of karthicklakshman Sent: 10 November 2010 15:06 To: r-help@r-project.org Subject: [R] Parsing txt file Hello, I have a tab limited text document with multiple lines as mentioned below, #FILE FORMAT #Book booknameauthor publisher pages #CD namecontent

[R] Parsing txt file

2010-11-10 Thread karthicklakshman
Hello, I have a tab limited text document with multiple lines as mentioned below, #FILE FORMAT #Book booknameauthor publisher pages #CD namecontent

Re: [R] Parsing txt file

2010-11-10 Thread jim holtman
-help@r-project.org Subject: [R] Parsing txt file Hello, I have a tab limited text document with multiple lines as mentioned below, #FILE FORMAT #Book   bookname        author  publisher       pages #CD     name    content

Re: [R] Parsing txt file

2010-11-10 Thread Mike Marchywka
From: santosh.srini...@gmail.com To: karthick.laksh...@gmail.com; r-help@r-project.org Date: Wed, 10 Nov 2010 16:00:26 +0530 Subject: Re: [R] Parsing txt file You could use the following to achieve your objective. To start with ?readLines

Re: [R] Parsing txt file

2010-11-10 Thread karthicklakshman
Hello Jim, hello all, Thanks very much for the inputs, I used the code and it solved my problem special thanks to Jim Holtman for the code. Regards, karthick -- View this message in context: http://r.789695.n4.nabble.com/Parsing-txt-file-tp3035749p3036284.html Sent from the R help