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/