[Download-List] Wrapping output in quotes
Bessler, Marc
mbessler at exeter.edu
Fri Sep 7 12:21:39 EDT 2012
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 <mailto:mbessler at exeter.edu>
Website: http://www.exeter.edu/alumni <http://phillips.exeter.edu/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120907/21d5c164/attachment.html>
More information about the download-list
mailing list