Rather than writing a simple program ... SELECT PARTS WITH EVAL "DCOUNT(F1, '"') GT 0"
Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: '[email protected]' Subject: [U2] RE: TCL literal select I tried using the lower case "SELECT/LIST" to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '"', '~') RETURN ED DICT PARTS F1.TILDA I SUBR("TILDA", F1) ... SELECT PARTS WITH F1.TILDA = "[~]" 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 Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- 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/
