I'm a U2 newbie, so can't test (EXECUTE is not in my VOC, sadly), but as an XP
guy, I have a couple of thoughts:
a) two parsers are involved (UV and XP), and the second one (XP) needs to see
the quote -- suggest using "" or even """ (i.e., escape the quote itself to be
sure it gets through to XP)
b) use "ECHO" in front of "DIR" to have XP print what it thinks it is about to
execute. So run:
>EXECUTE DOS /C ECHO DIR
""UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv""
Should report (somewhere!):
DIR "UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv"
c) if none of this helps, under xp, "cmd /?" provides some insight to quote
handling
Bill
-----Original Message-----
>From: Roger Glenfield <[EMAIL PROTECTED]>
>Sent: Apr 28, 2006 1:41 PM
>To: Eric Armstrong <[EMAIL PROTECTED]>
>Cc: [EMAIL PROTECTED], U2Users <[email protected]>
>Subject: Re: [U2] Escaping the '&' in Windows XP from Universe
>
>How about
>
>EXECUTE "DOS /C DIR UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv"
>
>So that it's all one command?
>
>And your fall back could always be to move the &HOLD& record into
>another file without the &s and Execute against it.
>
>Rog
>
>Eric Armstrong wrote:
>> Does anyone know how to escape the "&" in the following Basic EXECUTE
>> statement?
>>
>> EXECUTE DOS /C DIR UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv
>> CAPTURING msg RETURNING err
>>
>> Windows is choking on the "&". It thinks "HOLD" is a file in the LFC
>> directory.
>>
>> I tried the following-
>>
>> EXECUTE DOS /C DIR "UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv"
>> EXECUTE DOS /C DIR 'UVUSR\LFC\&HOLD&\INSRECAP\SutherlandIssues200604.csv'
>> EXECUTE DOS /C DIR UVUSR\LFC\&&HOLD&&\INSRECAP\SutherlandIssues200604.csv
>>
>> and a few other things, but no go.
>>
>> We are on
>> Universe 10.1.10
>> Windows XP 2002
>>
>> Thanks in advance.
>>
>> Eric Armstrong
>> Programmer/Analyst
>> Lobel Financial
>> 714.816.1207
>> 714.995.7012 fax
>> -------
>> u2-users mailing list
>> [email protected]
>> To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
----------------------------------------
Bill Hazard
email: [EMAIL PROTECTED]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/