[Download-List] Wrapping output in quotes

[Rotman, David]

One additional thought...
I think you may need single quotes around
P20.ACTREL.ACTIVITY.NAME<http://p20.actrel.activity.name/> in
your TRANS expression.



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/7451ffe8/attachment.html>