RE: [U2] [UD] "Escaping" a Quote
Rats, I was hoping someone knew how to do this. The best I've been able to figure out is to use ECLTYPE 'u' (lower case the 'verb') as it uses different characters like '...' instead of '[]'. Perhaps this was just lost in the flurry... Colin >-Original Message- >From: Kevin King > >Unidata 6.1: Is there a way to "escape a character" in a >SELECT literal? Though I can't see it in the documentation, I >know you can quote with the " or \ characters, but what if the >literal contains both " and \ characters? What then? Or what >if the value contains a "^" or "[" or "?" that aren't to be >interpreted by the query engine? > >??? > >-Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "Escaping" a Quote
In a SELECT literal? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 27, 2006 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] "Escaping" a Quote If my memory serves me I believe you can do something like this: EQU QT = char(39) EQU DQT = char(34) then do: VAR2 = \DQT:QT:VAR1:QT:DQT\ At least something similar. Karl > Unidata 6.1: Is there a way to "escape a character" in a SELECT > literal? Though I can't see it in the documentation, I know you can > quote with the " or \ characters, but what if the literal contains > both " and \ characters? What then? Or what if the value contains a > "^" or "[" or "?" that aren't to be interpreted by the query engine? > > ??? > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\<._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] "Escaping" a Quote
You can use single quotes in the SELECT statement. Example: SELECT FILE.NAME WITH @ID EQ '"1234"' will select the record with an id equal 1234 in quotes. (I tried it and it worked) Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, February 27, 2006 12:32 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] "Escaping" a Quote Unidata 6.1: Is there a way to "escape a character" in a SELECT literal? Though I can't see it in the documentation, I know you can quote with the " or \ characters, but what if the literal contains both " and \ characters? What then? Or what if the value contains a "^" or "[" or "?" that aren't to be interpreted by the query engine? ??? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] "Escaping" a Quote
If my memory serves me I believe you can do something like this: EQU QT = char(39) EQU DQT = char(34) then do: VAR2 = \DQT:QT:VAR1:QT:DQT\ At least something similar. Karl > Unidata 6.1: Is there a way to "escape a character" in a SELECT > literal? Though I can't see it in the documentation, I know you can > quote with the " or \ characters, but what if the literal contains > both " and \ characters? What then? Or what if the value contains a > "^" or "[" or "?" that aren't to be interpreted by the query engine? > > ??? > > -Kevin > [EMAIL PROTECTED] > http://www.PrecisOnline.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\<._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] "Escaping" a Quote
Unidata 6.1: Is there a way to "escape a character" in a SELECT literal? Though I can't see it in the documentation, I know you can quote with the " or \ characters, but what if the literal contains both " and \ characters? What then? Or what if the value contains a "^" or "[" or "?" that aren't to be interpreted by the query engine? ??? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/