edits help

[Kenneth Brody]

On 5/26/2011 2:26 PM, Jeff Harrison wrote:
> ----- Original Message ----
>
>> From: Linda Gray<lc_gray at yahoo.com>
[...]
>>> I need to  convert the ' to &39; or %27 using an edit.
>>>
[...]
> I would suggest that you NOT use an edit for this as well.  I don't think edits
> work very well when you don't know how many of the "from" characters may appear
> in the string.
>
> I would suggest doing this in processing - I think what you want to do is
> replace every occurance of chr("39") with "&#39;" that is the "html equivalent".
> (not url escape - I assume that is not your goal)
>
> Does filepro have a "replace" function?  I don't see one in 5.0 anyway.  Xlate
> seems to work on a character by character basis, so I don't think you can use
> that.  I think you will need to write this using mid and instr.
>
> I suppose Ken will now show us how to do this with an edit. :-)

     { @ | (!"'"!<&39;>) | * }

Of course, you still may need to pass the original string through TOHTML() 
first, to take care of the other characters.  (Or extend the above edit to 
handle the other characters as well.)

-- 
Kenneth Brody