Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Edit a file
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01416197
Message ID:
01416200
Vues:
78
>I have an xml file that I need to edit programatically to remove some text. This file is our payroll file and seems to convert to a cursor if I remove some tags. Here is a sample of the information:
>
>
><?xml version="1.0" encoding="utf-8" ?> 
>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs%
>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" 
>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract">
>- <table1>
>- <Detail_Collection>
>       <Detail PP ......
>       <Detail PP ......
>       <Detail PP ......
>   </Detail_Collection>
>  </table1>
></Report>
>
>
>the information I am trying to remove is:
>
>
>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs%
>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" 
>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract">
>
>
>and the end tag
>
>
></Report>
>
>
>is there anyway to edit this xml file programatically or even cycle through each line and rewrite it to another file picking up the lines I need?
>
>
>thanks
>Nick

It depends how big is that file:
lnLines = ALINES(laXML, FILETOSTR("your file with full path to it.XML")
FOR lnFor = 1 TO lnLines
    ? laXML[lnFor]
NEXT
But why you need to remove something in it?
Could you use XMLAdapter to get the file?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform