Discussion List
Subject: RE: EVAL and LIKE
Stu and everyone else,
Thanks for sticking with me but I'm going to ask you to take a look one
more time. I inserted your suggestion in line 9 This time I include my
full paragraph and the error message that comes up is a syntax error.
Anyone else re
Dear Kevin
Try this
EVAL IF FIELD.NAME[1] = * THEN 1 ELSE IF INDEX(FIELD.NAME,'Incomplete',1)
THEN 1 ELSE 0"
Regards
Sami Pierre Massarany
Mobile: 0414 408 229 or +61 414 408 229
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Kevin Michaelsen
Sent: Fr
Ken, you responded:
"TOTAL EVAL "(INDEX(H.CS.ADM.EST.NEED ,'*',1) OR INDEX(H.CS.ADM.EST.NEED
,'Incomplete',1))" \
Though I suspect that wouldn't actually do what you want because the INDEX
function returns an offset, not just 1 or zero. You'll have to make the
EVAL statement more complex with so
UNIQUERY. I tried in on UniVerse and
it works and should work on UniData.
-Original Message-----
From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 05, 2004 12:16 PM
To: U2 Users Discussion List
Subject: RE: EVAL and LIKE
I
on Thursday, February 05, 2004 12:16 PM Kevin Michaelsen wrote::
>I inserted your suggestion in line 9 This time I include
>my full paragraph and the error message that comes up is a syntax
>error.
[snip]
>009: TOTAL (INDEX(H.CS.ADM.EST.NEED ,'*',1) OR INDEX(H.CS.ADM.EST.NEED
,'Incomplete',1)) \
nd it works and should work on UniData.
-----Original Message-
From: Kevin Michaelsen
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 05, 2004 12:16 PM
To: U2 Users Discussion List
Subject: RE: EVAL and LIKE
I tried it. It didn't seem to work but maybe I didn't do it right. I
did inclu
It's
hard to help without seeing your error msgs. The [1] means the last byte
of FIELD.NAME. If any byte could contain "*" then perhaps
(INDEX(FIELD.NAME,'*',1) OR INDEX(FIELD.NAME,'Incomplete',1)) would work.
This should work in UNIQUERY. I tried in on UniVerse and it works and
should
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 05, 2004 10:16 AM
To: U2 Users Discussion List
Subject: RE: EVAL and LIKE
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 th
Title: Message
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 singl
Title: Message
If all
you need is just a count of records in a file with a particular field
containing the value "*" or "Incomplete":
COUNT file WITH field = '*' 'Incomplete'
-Original Message-From: Kevin Michaelsen
[mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004
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 s
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 AMTo: [EMAIL PROTECTED]Subject: EVAL and
LIKEI'm trying to g
12 matches
Mail list logo