I found I already answered this question before
Message ID: 1379402
>Hi,
>Now this question about FoxPro :))
>
>Simple example
>
>

>
>lcText = FILETOSTR("somefile.xml")
>
>lcValue = STREXTRACT(lcText,"<Desc>","</Descr>")
>
>

>
>This lcValue has "& and another html encoded characters inside"
>
>I want to convert it to Text and save in Character field
>
>Denis
>
>>>Hi,
>>>I have a text in the XML node encoded with HTML & and so on..
>>>What is easy way to convert this value to clear text?
>>>
>>>Thanks
>>>Denis
>>
>>Can you post a sample of what do you mean? You can use value() method of XML, check, for example
>>http://bradsruminations.blogspot.com/2009/10/making-list-and-checking-it-twice.html