Kevin:
A problem is the use
of the double-quote more than once - this will fail. Also, in your
original below you have the following clause using LIKE:
LIKE "'...*'
which will not work in the way you
want. Because the ...* is within the single quotes,
the LIKE statement will try to match on exactly that - it will seek fields that
are exactly three periods and an asterisk! Actually, if
you just want to count records, try this
COUNT FILE.NAME WITH FIELD.NAME LIKE "...'*'..." OR
WITH FIELD.NAME LIKE
"...'Incomplete'..."
Note that the specific strings you want to seek are inside
the single quotes, but the triple-dots are outside those but contained inside
the double quotes. (In pi/open you don't need the double quotes at
all).
Harold Oaks
Sr. Analyst/Programmer
Clark County, WA
-----Original Message-----I tried it. It didn't seem to work but maybe I didn't do it right. I did include the [1] in there. I'm a newbie, was I not suppose to. I'm also running this in a UNIQUERY statement at the colon prompt. Would that have anything to do with it not running properly. Thanks for whatever light you can shed on my case.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen
Sent: Thursday, February 05, 2004 9:16 AM
To: U2 Users Discussion List
Subject: RE: EVAL and LIKE
kevin
At 11:24 AM 2/5/2004 -0500, you wrote:
Perhaps this will help:
EVAL "IF (FIELD.NAME[1] = "*" OR INDEX(FIELD.NAME,'Incomplete',1)) THEN 1 ELSE 0"--
- -----Original Message-----
- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]]
- Sent: Thursday, February 05, 2004 11:14 AM
- To: [EMAIL PROTECTED]
- Subject: EVAL and LIKE
- I'm trying to get this statement to work:
- Basically I'm trying to count the number of records that have a FIELD.NAME that has an "*" or an "Incomplete".
- TOTAL EVAL "IF(WITH FIELD.NAME LIKE "'...*','Incomplete'") THEN COUNTER ELSE 0"
- Thanks for any assistance.
- Kevin
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
