[R] Urgent Help - Editing XML through R

[jim holtman]

Here is one way using the XML package:


> x <- '<?xml version="1.0" encoding="utf-8"?>
+ <as:Job xmlns:as="urn:tibco:spotfire.dxp.automation">
+   <as:Tasks>
+     <OpenAnalysisFromLibrary
+ xmlns="urn:tibco:spotfire.dxp.automation.tasks">
+       <as:Title>Open Analysis from Library</as:Title>
+       <AnalysisPath>/Z- Archive - TO BE
+ purged/ConditionEmailTest</AnalysisPath>
+     </OpenAnalysisFromLibrary>
+     <SendEmail xmlns="urn:tibco:spotfire.dxp.automation.tasks">
+       <as:Title>Send Email</as:Title>
+       <Recipients>
+         <string>chidambaramselvakumar at gmail.com</string>
+ <string>chidambaramselvakumar at gmail.com</string>
+       </Recipients>
+       <Subject>Sales Report</Subject>
+       <Message>Hi,
+
+ Good Day!
+
+ Thanks for achieving your sales target.
+
+ Regards,
+ Chidambaram</Message>
+       <Links />
+       <Attachments />
+     </SendEmail>
+   </as:Tasks>
+ </as:Job>'
> require(XML)
>
> doc <- xmlParse(x)
> docRoot <- xmlRoot(doc)
>



> # change the second email and then output
> docRoot[["Tasks"]][["SendEmail"]][["Recipients"]][[2]][['text']] <- "
name at domain.tv"
> print(docRoot)



<as:Job xmlns:as="urn:tibco:spotfire.dxp.automation">
  <as:Tasks>
    <OpenAnalysisFromLibrary
xmlns="urn:tibco:spotfire.dxp.automation.tasks">
      <as:Title>Open Analysis from Library</as:Title>
      <AnalysisPath>/Z- Archive - TO BE
purged/ConditionEmailTest</AnalysisPath>
    </OpenAnalysisFromLibrary>
    <SendEmail xmlns="urn:tibco:spotfire.dxp.automation.tasks">
      <as:Title>Send Email</as:Title>
      <Recipients>
        <string>chidambaramselvakumar at gmail.com</string>
        <string>name at domain.tv</string>
      </Recipients>
      <Subject>Sales Report</Subject>
      <Message>Hi,

Good Day!

Thanks for achieving your sales target.

Regards,
Chidambaram</Message>
      <Links/>
      <Attachments/>
    </SendEmail>
  </as:Tasks>
</as:Job>



Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.

On Fri, Nov 14, 2014 at 12:34 PM, Chidambaram Selvakumar <
chidambaramselvakumar at gmail.com> wrote:

> Hi Team,
>
> Can you please help me on the below?
>
> 1) Is it possible to achieve the below requirement through or not?
>        Open XMl; find and remove the all the string tag;add new string tag
> based on the email count; save it in the same XML.
> 2) If yes can you please share the script
>
> As I am new to R script, I am expecting your help to achieve this.
>
> Thanks in advance.
>
> Regards
> Chidambaram
> On Nov 8, 2014 1:10 PM, "Chidambaram Selvakumar" <
> chidambaramselvakumar at gmail.com> wrote:
> >
> > Hi Team,
> >
> > I have the below xml file where i have to find and remove all the email
> address in <string> tag and need to append the new email address using R
> script.May be string tag needs to be added or decreased based on the email
> list.
> >
> > XM File
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <as:Job xmlns:as="urn:tibco:spotfire.dxp.automation">
> >   <as:Tasks>
> >     <OpenAnalysisFromLibrary
> xmlns="urn:tibco:spotfire.dxp.automation.tasks">
> >       <as:Title>Open Analysis from Library</as:Title>
> >       <AnalysisPath>/Z- Archive - TO BE
> purged/ConditionEmailTest</AnalysisPath>
> >     </OpenAnalysisFromLibrary>
> >     <SendEmail xmlns="urn:tibco:spotfire.dxp.automation.tasks">
> >       <as:Title>Send Email</as:Title>
> >       <Recipients>
> >         <string>chidambaramselvakumar at gmail.com</string>
> > <string>chidambaramselvakumar at gmail.com</string>
> >       </Recipients>
> >       <Subject>Sales Report</Subject>
> >       <Message>Hi,
> >
> > Good Day!
> >
> > Thanks for achieving your sales target.
> >
> > Regards,
> > Chidambaram</Message>
> >       <Links />
> >       <Attachments />
> >     </SendEmail>
> >   </as:Tasks>
> > </as:Job>
> >
> > Kindly help me. It is little urgent.
> >
> > Thanks in advance for your effort and support.
> >
> > Regards,
> > Chidambaram
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>

	[[alternative HTML version deleted]]