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/
