Marc--<div><br></div><div>Thanks for the note.</div><div><br></div><div>We don't use those particular files, so it's a little hard to test here.</div><div><br></div><div>I did wonder about the 'reuse' expression in your TRANS. The 'reuse' is necessary in the SPLICE statement, but shouldn't be needed on the TRANS.</div>
<div><br></div><div><br clear="all">David Rotman, Ph.D.<br>Associate Vice President for Technology<br>Chief Information Officer<br>Cedarville University<br>251 N. Main Street<br>Cedarville, OH 45314<br><a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>
voice 937-766-7905<br>fax 937-766-8819<div><img src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><br></div><br>
<br><br><div class="gmail_quote">On Fri, Sep 7, 2012 at 12:21 PM, Bessler, Marc <span dir="ltr"><<a href="mailto:mbessler@exeter.edu" target="_blank">mbessler@exeter.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="color:#365f91">Is there a way to wrap the output of an EVAL expression in single quotes? I am doing a SPLICE to create a record ID that contains an asterisk *. However, in order for it to be read as a record ID and not a string I need it in single quotes.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#365f91"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#365f91">DOWNLOAD ACTIVREL <a href="http://ACTIVREL.DONOR.ID" target="_blank">ACTIVREL.DONOR.ID</a> EVAL "<a href="http://ACTIVREL.DONOR.ID" target="_blank">ACTIVREL.DONOR.ID</a>;TRANS('ACTIVITY',ACTIVREL.ACTIVITY,'COMPONENT.EVENTS','X');SUBR('-SPLICE',REUSE(@1),'*',REUSE(@2));TRANS('ACTIVREL',REUSE(@3),<a href="http://P20.ACTREL.ACTIVITY.NAME" target="_blank">P20.ACTREL.ACTIVITY.NAME</a>,'X')" NUM.VALUES ALL<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#365f91"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#365f91">If I end this right after the SPLICE command, I can see that it is generating what I want – DONOR*ACTIVITY – however trying to use that in the final trans results in nulls because Colleague isn’t reading it as a record id. However it is outputting the correct amount of nulls (one for each component) so it seems to be iterating through correctly. Any thoughts?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif""><u></u><u></u><span style="color:#990000">Marc</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">Bessler<br>
</span><u></u><u></u><u></u><u></u><span style="color:#990000">Technology</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">Support</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">Specialist</span><u></u><span style="color:#990000"><br>
</span><u></u><span style="color:#990000">Phillips</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">Exeter</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">Academy</span><u></u><u></u></span><span style="color:#365f91"><br>
</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#990000">20 </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif""><u></u><u></u><span style="color:#990000">Main Street</span><u></u><span style="color:#990000"><br>
</span><u></u><span style="color:#990000">Exeter</span><u></u><span style="color:#990000">, </span><u></u><span style="color:#990000">NH</span><u></u><span style="color:#990000"> </span><u></u><span style="color:#990000">03833</span><u></u><u></u></span><span style="color:#365f91"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u><u></u><u></u><u></u><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#365f91">Telephone: <a href="tel:603-777-3367" value="+16037773367" target="_blank">603-777-3367</a><br>
Fax: <a href="tel:603-777-4382" value="+16037774382" target="_blank">603-777-4382</a><br>Email: </span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#365f91"><a href="mailto:mbessler@exeter.edu" title="mailto:mbessler@exeter.edu" target="_blank"><span style="font-family:"Verdana","sans-serif";color:blue">mbessler@exeter.edu</span></a><br>
</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#365f91">Website: </span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#365f91"><a href="http://phillips.exeter.edu/" title="http://phillips.exeter.edu/" target="_blank"><span style="font-family:"Verdana","sans-serif";color:blue">http://www.exeter.edu/alumni</span></a></span><span style="color:#365f91"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#365f91"> </span><span style="color:#365f91"><u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p></div></div><br>_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
<br></blockquote></div><br></div>