Using tohtml to translate &amp

[Brian K. White]

On 6/24/2011 5:09 PM, Mike Schwartz wrote:
>>>      I have to read some incoming XML files that are encoded with&amp,
>>> &gt, etcetera.  filePro 5.0.14 doesn't have a "FROMHTML()" function
>> available.
>
>       Ok, I *ALMOST* have the following edit working to un-unicode a field.
> I just have a problem with how to quote the<  and>  character:


I don't see any unicode anywhere in here.


> ununi  °{ {!" "!} @ | !&amp;!<&>  | !&lt;!<"<">  | !&gt;!<"<">  | *}
>
>      This string works OK for 1 or more "&amp;" strings.  It removes the
> "&amp;", replaces it with an "&" and closes up the extra spaces.
>
>      However, with a "test&lt; test" string, it gives leaves me with a
> string looking like "test&lt; test" and with "test&gt; test" it gives me a
> syntax error.
>
> The following string seems to work:
>
> ununi  °{ {!" "!} @ | !&amp;!<&>  | !&lt;!<z>  | !&gt;!<q>  | *}
>
>      any suggestions?

-- 
bkw