>>>>>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?
>>>
>>>I tried the following code:
>>>
>>>

>>>LOCAL oxml as XMLAdapter
>>>oxml = NEWOBJECT("xmladapter")
>>>oxml.LoadXML("C:\test2\PayRegExtract.xml")
>>>

>>>
>>>and it gave me following error:
>>>
>>>

>>>XML Error: XML Parse error: Invalid at top level of the document.
>>>Line 1, Position 1 C:\test\PayRegExtract.xml
>>>

>>>
>>>Then I tried
>>>
>>>

>>>SELECT * from xfer_payroll INTO CURSOR crsparse readwrite
>>>SELECT crsparse
>>>XMLTOCURSOR("C:\test2\PayRegExtract.xml","crsparse",512)
>>>browse
>>>

>>>
>>>and the cursor shows Detail_Collection column only
>>>
>>>next I tried West Wind Client Tools and remove the all the tags except for table1
>>>

>>><?xml version="1.0"?>
>>><table1>
>>>	<Detail_Collection>
>>>		<Detail PP="
>>>...
>>>...
>>>	</Detail_Collection>
>>></table1>
>>>

>>>
>>>and that works like a charm. So I was think of removing the offending tags programatically and running the xml through West Wind XML tools. I'm not very savy with XML, how would I correct the XMLAdapter issue (how is it that used, couldn't understand examples) or XMLTOCURSOR issue? The file is 1.5mb.
>>
>>
>>Check RespectNesting property in XMLAdapter.
>
>Couldn't find such feature in help. I read another posting say it is vfp9 feature. I'm using vfp8. thanks. nick.


Sorry Nick,
I didn't pay attention of the version you use.