<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You could use n=strtok(“’”)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>N will be the location of the first instance of ‘. You could then test the value of the next character(s). If it what you expect, use mid to replace the ‘ with whatever character(s) you want.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Richard<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Linda Gray [mailto:lc_gray@yahoo.com] <br><b>Sent:</b> Thursday, May 26, 2011 2:41 PM<br><b>To:</b> Richard Kreiss; Jeff Harrison; filepro-list@lists.celestial.com<br><b>Subject:</b> Re: edits help<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-family:"Garamond","serif"'>toHTML doesn't work for '<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Garamond","serif"'><o:p> </o:p></span></p><div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Richard Kreiss <rkreiss@verizon.net><br><b>To:</b> Jeff Harrison <jeffaharrison@yahoo.com>; Linda Gray <lc_gray@yahoo.com>; filepro-list@lists.celestial.com<br><b>Sent:</b> Thu, May 26, 2011 1:32:13 PM<br><b>Subject:</b> RE: edits help<br><br><br><br>> -----Original Message-----<br>> From: filepro-list-bounces+rkreiss=<a href="mailto:verizon.net@lists.celestial.com">verizon.net@lists.celestial.com</a><br>> [mailto:filepro-list-bounces+rkreiss=<a href="mailto:verizon.net@lists.celestial.com">verizon.net@lists.celestial.com</a>] On<br>> Behalf Of Jeff Harrison<br>> Sent: Thursday, May 26, 2011 2:27 PM<br>> To: Linda Gray; <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a><br>> Subject: Re: edits help<br>> <br>> ----- Original Message ----<br>> <br>> > From: Linda Gray <<a href="mailto:lc_gray@yahoo.com">lc_gray@yahoo.com</a>><br>> > To: Jay Ashworth <<a href="mailto:jra@baylink.com">jra@baylink.com</a>>; <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a><br>> > Sent: Thu, May 26, 2011 1:13:21 PM<br>> > Subject: Re: edits help<br>> ><br>> > i'm not worried about the length of the end string. i need to replace<br>the '<br>> > with an html friendly string like the toHTML command does, except it<br>> >doesn't do<br>> ><br>> > the single quote. it was suggested that i do it with an edit.<br>> ><br>> ><br>> ><br>> ><br>> > ________________________________<br>> > From: Jay Ashworth <<a href="mailto:jra@baylink.com">jra@baylink.com</a>><br>> > To: <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a><br>> > Sent: Thu, May 26, 2011 11:12:32 AM<br>> > Subject: Re: edits help<br>> ><br>> > ----- Original Message -----<br>> > > From: "Linda Gray" <<a href="mailto:lc_gray@yahoo.com">lc_gray@yahoo.com</a>><br>> ><br>> > > I need to convert the ' to ' or %27 using an edit.<br>> > ><br>> > > I'm not good at defining edits and sure would appreciate some help.<br>> > ><br>> > > I need to replace the ' with it's HTML equivalent before writing<br>> > > out ajax script that uses ' for strings and have names with ' in<br>them.<br>> ><br>> > So you need to URLescape an ASCII string; that's your end goal?<br>> ><br>> > My snap reaction is "you don't want to do that with an edit, because<br>> > you can't guarantee how many characters you'll have to replace, and<br>> > you'll run out of space". You *probably* want to write code to do<br>> > that, as difficult as it is to handle functions in filePro.<br>> ><br>> > Cheers,<br>> > -- jra<br>> > --<br>> > Jay R. Ashworth Baylink<br><a href="mailto:jra@baylink.com">jra@baylink.com</a><br>> > Designer The Things I Think RFC<br>2100<br>> > Ashworth & Associates <a href="http://baylink.pitas.com">http://baylink.pitas.com</a> 2000 Land Rover<br>DII<br>> > St Petersburg FL USA <a href="http://photo.imageinc.us">http://photo.imageinc.us</a> +1 727<br>647<br>> 1274<br>> <br>> <br>> I would suggest that you NOT use an edit for this as well. I don't think<br>edits<br>> work very well when you don't know how many of the "from" characters<br>> may appear 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<br>> 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.<br>Xlate<br>> seems to work on a character by character basis, so I don't think you can<br>use<br>> that. I think you will need to write this using mid and instr.<br><br>SEE TOHTML()<br><br>Richard<br><br>> <br>> I suppose Ken will now show us how to do this with an edit. :-)<br>> <br>> Jeff Harrison<br>> <a href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a><br>> Author of JHExport and JHImport<br>> _______________________________________________<br>> Filepro-list mailing list<br>> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>> Subscribe/Unsubscribe/Subscription Changes<br>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br><br><o:p></o:p></span></p></div></div></div></div></div></body></html>