Jeff, In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... which may be just what you want.
Eric Armstrong Programmer/Analyst Lobel Financial 714-816-1207 -----Original Message----- From: Ron Hutchings [mailto:[EMAIL PROTECTED] Sent: Sunday, June 22, 2008 3:27 PM To: [email protected] Subject: RE: [U2] Friday query logic I experimented with it and got much closer with: SELECT FILE WITH EVERY FIELD UNLIKE "SF..." AND WITH EVERY FIELD UNLIKE "SH... It is not quite what you want but much closer. > From: [EMAIL PROTECTED] > To: [email protected] > Subject: [U2] Friday query logic > Date: Fri, 20 Jun 2008 11:25:30 -0400 > > I can't get my head around the proper query logic on this Friday. > > I have a FILE with mv FIELD containing strings. I want to query records where > at least one of the FIELD values doesn't begin with "SF..." or "SH...". > > To be clear: I don't want records if any of the following occurs: > > FIELD = 'SF123' > FIELD = 'SH456' > FIELD = 'SF123':@VM:'SH456' > > but I do want records if any of these occur: > > FIELD='PQ789' > FIELD='SF123':@VM:'XY789' > FIELD='SF123':@VM:'SH456':@VM:'GH789' > > ---------------- > I tried > > SELECT FILE WITH FIELD UNLIKE "SF...""SH..." > and > SELECT FILE WITH FIELD UNLIKE "SF..." AND FIELD UNLIKE "SH..." > > but those include records where FIELD='SF123':@VM:'SH456'. > > Then I tried > > SELECT FILE WITH NO FIELD LIKE "SF...""SH..." > and > SELECT FILE WITH NO FIELD LIKE "SF..." AND NO FIELD LIKE "SH..." > > but that throws out records where FIELD='SF123':@VM:'SH456':@VM:'GH789' which > I need to keep. I've tried some others variants using 'EVERY' but to no > avail. > > So, I'm as a loss short of writing a I-descriptor. Anyone have their logic > cap on today? > > > -- > Jeff Butera, Ph.D. > Administrative Systems > Hampshire College > [EMAIL PROTECTED] > 413-559-5556 > > "Email gives the illusion of progress even when > nothing is happening." unknown > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ _________________________________________________________________ The im Talkathon starts 6/24/08. For now, give amongst yourselves. http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
