edits help

[Linda Gray]

thanks so much ken, that really helps.




________________________________
From: Kenneth Brody <kenbrody at spamcop.net>
To: Jeff Harrison <jeffaharrison at yahoo.com>
Cc: filepro-list at lists.celestial.com; Linda Gray <lc_gray at yahoo.com>
Sent: Thu, May 26, 2011 1:47:19 PM
Subject: Re: edits help

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 "'" 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
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20110526/a04ff6d6/attachment.html