[Download-List] Wrapping output in quotes

[Rotman, David]

Marc--

Thanks for the note.

We don't use those particular files, so it's a little hard to test here.

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.


David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819




On Fri, Sep 7, 2012 at 12:21 PM, Bessler, Marc <mbessler at exeter.edu> wrote:

> 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.****
>
> ** **
>
> DOWNLOAD ACTIVREL ACTIVREL.DONOR.ID  EVAL "ACTIVREL.DONOR.ID
> ;TRANS('ACTIVITY',ACTIVREL.ACTIVITY,'COMPONENT.EVENTS','X');SUBR('-SPLICE',REUSE(@1),'*',REUSE(@2));TRANS('ACTIVREL',REUSE(@3),
> P20.ACTREL.ACTIVITY.NAME,'X')" NUM.VALUES ALL****
>
> ** **
>
> 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?**
> **
>
> ****Marc** **Bessler
> ********Technology** **Support** **Specialist**
> **Phillips** **Exeter** **Academy****
> 20 ****Main Street**
> **Exeter**, **NH**  **03833********
>
> ********Telephone: 603-777-3367
> Fax: 603-777-4382
> Email: mbessler at exeter.edu
> Website: http://www.exeter.edu/alumni <http://phillips.exeter.edu/>****
>
>  ****
>
> ** **
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120910/60cd4bf2/attachment.html>