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
RE: EVAL and LIKE
Title: Message If all you need is justa 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 10:16 AMTo: U2 Users Discussion ListSubject: RE: EVAL and LIKEI 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.kevinAt 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
RE: EVAL and LIKE
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 single quotes, the LIKE statement will try to match on exactly that - it will seek fields that are exactlythree periods and an asterisk!Actually, if you just want to count records, try this COUNTFILE.NAMEWITH FIELD.NAMELIKE "...'*'..." OR WITHFIELD.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/openyou don't need the double quotes at all). Harold Oaks Sr. Analyst/Programmer Clark County, WA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin MichaelsenSent: Thursday, February 05, 2004 9:16 AMTo: U2 Users Discussion ListSubject: RE: EVAL and LIKEI 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.kevinAt 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