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
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
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
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
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)
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
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
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
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
] 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
Hello,
I have a tab limited text document with multiple lines as mentioned below,
#FILE FORMAT
#Book booknameauthor publisher pages
#CD namecontent
-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
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
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
14 matches
Mail list logo