[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