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: [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
