RE: [U2] TCL literal select
David: That will work on my UD system, in PICK mode (using the UD parser). Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of David A. Green >Sent: Thursday, August 14, 2008 5:56 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] TCL literal select > >Try: > >LIST PARTS F1 WITH EVAL "COUNT(F1, CHAR(034))" NE 0 > >Thanks, >David A. Green >www.dagconsulting.com >(480) 813-1725 > > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway >Sent: Tuesday, August 12, 2008 1:00 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] TCL literal select > >Hi, > >I work with a Unidata/Dataflo system on HPUX. >I am having trouble selecting records in my PARTS file. > >I want to select all parts that have a " in the description field (F1). >People have been using " instead of INCH. >This causes problems for me during processing some reports and exports. > >I have tried quite a few select statements with no success. > >LIST PARTS WITH F1 = "[/"/]" >LIST PARTS WITH F1 = "/"/" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = "['"']" >LIST PARTS WITH F1 = "'"'" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = \["]\ >LIST PARTS WITH F1 = "[\"\]" >LIST PARTS WITH F1 = '"' > >Wildcards on my system are brackets, [ leading and ] following > >Any ideas on what would work? >Somebody showed me once, so I know it can be done. >I lost my notes though. > >Thanks, > >Bruce Ordway > > >Viking Engineering & Development Inc. >5750 Main St. N.E. >Fridley, MN 55432 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
Or simply use a lower case "LIST" (i.e. "list") to force it to ECLTYPE U for that one statement. This works for "list ...", "select ...", etc. This is a VERY useful way to use "U" flavored syntax in a "P" environment. There is a similar command for compiling basic programs. Make the first line of your code (even a subroutine): $BASICTYPE "P" or $BASICTYPE "U" to force it to compile in the desired mode. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kebbon Irwin Sent: Thursday, August 14, 2008 10:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select I think Bruce must in ECLTYPE P if he is using the [] wild cards, so he will have to convert to ECLTYPE U to use the EVAL keyword (i.e. lIST or list ...) to test your suggestion. >From: "David A. Green" <[EMAIL PROTECTED]> >Reply-To: u2-users@listserver.u2ug.org >To: >Subject: RE: [U2] TCL literal select >Date: Thu, 14 Aug 2008 05:55:46 -0700 > >Try: > >LIST PARTS F1 WITH EVAL "COUNT(F1, CHAR(034))" NE 0 > >Thanks, >David A. Green >www.dagconsulting.com >(480) 813-1725 > > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway >Sent: Tuesday, August 12, 2008 1:00 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] TCL literal select > >Hi, > >I work with a Unidata/Dataflo system on HPUX. >I am having trouble selecting records in my PARTS file. > >I want to select all parts that have a " in the description field (F1). >People have been using " instead of INCH. >This causes problems for me during processing some reports and exports. > >I have tried quite a few select statements with no success. > >LIST PARTS WITH F1 = "[/"/]" >LIST PARTS WITH F1 = "/"/" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = "['"']" >LIST PARTS WITH F1 = "'"'" >LIST PARTS WITH F1 = "/'"'/" >LIST PARTS WITH F1 = \["]\ >LIST PARTS WITH F1 = "[\"\]" >LIST PARTS WITH F1 = '"' > >Wildcards on my system are brackets, [ leading and ] following > >Any ideas on what would work? >Somebody showed me once, so I know it can be done. >I lost my notes though. > >Thanks, > >Bruce Ordway > > >Viking Engineering & Development Inc. >5750 Main St. N.E. >Fridley, MN 55432 > >Visit us at www.Vikingeng.com > >This message contains confidential information and is intended only for the >individual named. If you are not the named addressee you should not >disseminate, distribute or copy this e-mail. Please notify the sender >immediately by e-mail if you have received this e-mail by mistake and >delete >this e-mail from your system. E-mail transmission cannot be guaranteed to >be >secure or error-free as information could be intercepted, corrupted, lost, >destroyed, arrive late or incomplete, or contain viruses. The sender >therefore does not accept liability for any errors or omissions in the >contents of this message, which arise as a result of e-mail transmission. >If >verification is required please request a hard-copy version. >--- >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/ --- 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] TCL literal select
I think Bruce must in ECLTYPE P if he is using the [] wild cards, so he will have to convert to ECLTYPE U to use the EVAL keyword (i.e. lIST or list ...) to test your suggestion. From: "David A. Green" <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: Subject: RE: [U2] TCL literal select Date: Thu, 14 Aug 2008 05:55:46 -0700 Try: LIST PARTS F1 WITH EVAL "COUNT(F1, CHAR(034))" NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
Try: LIST PARTS F1 WITH EVAL "COUNT(F1, CHAR(034))" NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] TCL literal select
Bill Haskett wrote: Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode. I wasn't able to get any of the suggestions to work in UD. Bill I just created a temporary account on a Universe machine, in PICK flavor. And ran right into the same problem. Which suggests to me that I test my answers before I present them. -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
Allen, Changing the first letter of the verb forces processing of the query in 'U'nidata mode so you have to use 'LIKE' instead of '='. If that doesn't work, try a virtual dictionary item that calls a subroutine that outputs "IN" for every occurance of '"'. Tom -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 12:48 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode. I wasn't able to get any of the suggestions to work in UD. Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Allen Egerton >Sent: Tuesday, August 12, 2008 6:56 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] TCL literal select > >Bruce Ordway wrote: >> Hi, >> >> I work with a Unidata/Dataflo system on HPUX. >> I am having trouble selecting records in my PARTS file. >> >> I want to select all parts that have a " in the description field (F1). >> People have been using " instead of INCH. >> This causes problems for me during processing some reports and exports. >> > >To include double-quote within field to be searched, use single quote >as delimiter. > >SELECT PARTS WITH F1 = '["' >-or- >SELECT PARTS WITH F1 LIKE '..."...' > > >-- >Allen Egerton >aegerton at pobox dot 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] TCL literal select
Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode. I wasn't able to get any of the suggestions to work in UD. Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Allen Egerton >Sent: Tuesday, August 12, 2008 6:56 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] TCL literal select > >Bruce Ordway wrote: >> Hi, >> >> I work with a Unidata/Dataflo system on HPUX. >> I am having trouble selecting records in my PARTS file. >> >> I want to select all parts that have a " in the description field (F1). >> People have been using " instead of INCH. >> This causes problems for me during processing some reports and exports. >> > >To include double-quote within field to be searched, use single quote as >delimiter. > >SELECT PARTS WITH F1 = '["' >-or- >SELECT PARTS WITH F1 LIKE '..."...' > > >-- >Allen Egerton >aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
I would suggest creating INDEX to access, build and maintain. 1. create a virtual dictionary called CHECKINCH with the following on line 2. IF INDEX(F1,'"',1) THEN 1 ELSE 0 2. create a virtual dictionary called INCH with this on line 2. IF CHECKINCH THEN F1 ELSE "" 3. CREATE.INDEX PARTS INCH NO.NULLS To view the data LIST.INDEX PARTS INCH DETAIL Now you have just the INCH records identified to do with as you like, and any adds, deletes or modifications get automatically done with no coding. You can now also use SETINDEX and SELECTINDEX to go directly where a key should be in the file or grab the entire file that has INCH. Nick Nicholas M Gettino | Director of Development | EnRoute Emergency Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389 [EMAIL PROTECTED] | www.enroute911.com Register Now! | EnRoute Emergency Systems Customer Conference | September 22-25, 2008 | Mainsail Suites Hotel & Conference Center | Tampa, Florida -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Tuesday, August 12, 2008 9:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL literal select Bruce Ordway wrote: > Hi, > > I work with a Unidata/Dataflo system on HPUX. > I am having trouble selecting records in my PARTS file. > > I want to select all parts that have a " in the description field (F1). > People have been using " instead of INCH. > This causes problems for me during processing some reports and exports. > To include double-quote within field to be searched, use single quote as delimiter. SELECT PARTS WITH F1 = '["' -or- SELECT PARTS WITH F1 LIKE '..."...' -- Allen Egerton aegerton at pobox dot 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] TCL literal select
Bruce Ordway wrote: Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. To include double-quote within field to be searched, use single quote as delimiter. SELECT PARTS WITH F1 = '["' -or- SELECT PARTS WITH F1 LIKE '..."...' -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] TCL literal select
or LIST PARTS WITH F1 LIKE \..."...\ I find dots easier to type then left and right brackets. -- Louie in Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL literal select
Consider trying... LIST PARTS WITH F1 LIKE '..."...' --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] TCL literal select
LIST PARTS WITH F1 = /["]/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: 12 August 2008 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Internal Virus Database is out of date. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1599 - Release Date: 07/08/2008 20:49 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] TCL literal select
Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a " in the description field (F1). People have been using " instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = "[/"/]" LIST PARTS WITH F1 = "/"/" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = "['"']" LIST PARTS WITH F1 = "'"'" LIST PARTS WITH F1 = "/'"'/" LIST PARTS WITH F1 = \["]\ LIST PARTS WITH F1 = "[\"\]" LIST PARTS WITH F1 = '"' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering & Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/