Thanks Stu and Ken the line worked flawlessly.

kevin


At 05:43 PM 2/5/2004 -0500, you wrote:
On line 9, you left out the EVAL.  See line 8 to see your mistake.
-----Original Message-----
From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:57 PM
To: U2 Users 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 reading please feel free to contribute. Many thanks for any thoughts.

kevin

001: PA RUNS FIN AID STATS
002: LIST CS.2004 \
003: WITH H.CS.APPL.START.TERM = '04/FA'\
004: WITH H.CS.ACCEPTS = Y \
005: BY H.CS.APPL.ADMIT.STATUS BREAK.ON H.CS.APPL.ADMIT.STATUS \
006: TOTAL COUNTER TOTAL EVAL "IF(H.HCG.AWARDED.ALL>
0) THEN COUNTER ELSE 0" FMT '5' COL.HDG "W/HCG" \
007: TOTAL H.HCG.AWARDED.ALL AVERAGE H.HCG.AWARDED.ALL NO.NULLS \
008: TOTAL EVAL "IF(H.CS.ADM.EST.NEED = 'Incomplete')THEN COUNTER ELSE 0" \
009: TOTAL (INDEX(H.CS.ADM.EST.NEED ,'*',1) OR INDEX(H.CS.ADM.EST.NEED ,'Incompl
ete',1)) \
010: HEADER "'C' Financial Aid stats'LL''TC''LL'" ID.SUP DET.SUP




At 02:50 PM 2/5/2004 -0500, you wrote:
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 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 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.

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

--
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

Reply via email to