<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:garamond, new york, times, serif;font-size:12pt"><DIV>thanks so much ken, that really helps.<BR></DIV>
<DIV style="FONT-FAMILY: garamond, new york, times, serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: tahoma, new york, times, serif; FONT-SIZE: 10pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Kenneth Brody <kenbrody@spamcop.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Jeff Harrison <jeffaharrison@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> filepro-list@lists.celestial.com; Linda Gray <lc_gray@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thu, May 26, 2011 1:47:19 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: edits help<BR></FONT><BR>On 5/26/2011 2:26 PM, Jeff Harrison wrote:<BR>> ----- Original Message ----<BR>><BR>>> From: Linda Gray<<A href="mailto:lc_gray@yahoo.com" ymailto="mailto:lc_gray@yahoo.com">lc_gray@yahoo.com</A>><BR>[...]<BR>>>> I need to convert the ' to &39; or %27 using an edit.<BR>>>><BR>[...]<BR>> I would suggest that you NOT use an edit for this as well. I don't think edits<BR>> work very well when you don't know how many of
the "from" characters may appear<BR>> in the string.<BR>><BR>> I would suggest doing this in processing - I think what you want to do is<BR>> replace every occurance of chr("39") with "'" that is the "html equivalent".<BR>> (not url escape - I assume that is not your goal)<BR>><BR>> Does filepro have a "replace" function? I don't see one in 5.0 anyway. Xlate<BR>> seems to work on a character by character basis, so I don't think you can use<BR>> that. I think you will need to write this using mid and instr.<BR>><BR>> I suppose Ken will now show us how to do this with an edit. :-)<BR><BR> { @ | (!"'"!<&39;>) | * }<BR><BR>Of course, you still may need to pass the original string through TOHTML() <BR>first, to take care of the other characters. (Or extend the above edit to <BR>handle the other characters as well.)<BR><BR>-- <BR>Kenneth
Brody<BR>_______________________________________________<BR>Filepro-list mailing list<BR><A href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</A><BR>Subscribe/Unsubscribe/Subscription Changes<BR>http://mailman.celestial.com/mailman/listinfo/filepro-list<BR></DIV></DIV></div></body></html>