You might try, counting zeros instead of comparing values or combining count with another function. . You might split out the groups, I can't remember the function, but it groups things and then you work with groups. i.e. count(first group) compare count(second group).
000 would not equal 0 Mark On Aug 15, 2011, at 9:31 AM, WebDude wrote: > Any ideas? > > > > > From: WebDude [mailto:webd...@cipromo.com] > Sent: Monday, August 15, 2011 9:39 AM > To: Witango-Talk@witango.com > Subject: RE: Witango-Talk: Exact Numeric Character IFs > > This is what I need... > > 0 = 0 True > 00 = 0 False > > Simply changing the TRUE and FALSE values does not work. Both of these equate > to TRUE. > > All of these equate to true too... > > <@IF EXPR="'000' = '0'" TRUE ="true" FALSE="false"> > <@IF EXPR="'0' = '0'" TRUE ="true" FALSE="false"> > <@IF EXPR="00000 = 0" TRUE ="true" FALSE="false"> > <@IF EXPR="0 = 0" TRUE ="true" FALSE="false"> > <@IFEQUAL "00" "0000">true<@ELSE>false</@IF> > <@IFEQUAL "0" "0">true<@ELSE>false</@IF> > > > > > > From: Bill Downall [mailto:bdown...@downallconsulting.com] > Sent: Monday, August 15, 2011 9:24 AM > To: Witango-Talk@witango.com > Subject: Re: Witango-Talk: Exact Numeric Character IFs > > John, > > It seems to me like you should reverse your TRUE and FALSE values. > > Bill > > On Monday, August 15, 2011, WebDude <webd...@cipromo.com> wrote: > > This has never come up before and I know it's probably a stupid question, > > but I am trying to write an IF statement where I need to compare characters > > rather then numbers. I went through the manual and I am a bit confused. I > > thought that if you used single quotes, it would look at the expression as > > a character compare rather then a numeric compare. For example... > > > > <@IF EXPR="'00000 = '0'" TRUE ="They really are not the same - one has a > > lot more zeros then the other" FALSE="They are the same"> > > > > I have a client who has numeric codes that can start with multiple zeros > > and I need to be able to get a true or false depending on the actual > > characters rather then the numeric value. > > > > 00000 = 0 would then be false. > > > > Probably a stupid fix, I just cannot see it. By the way, the <@IFEQUAL> tag > > evaluates the same way. I need a string comparison rather the numeric. > > > > Any help would be appreciated. > > > > Thanks! > > > > John M. > > > > > > > > > > > > ________________________________ > > To unsubscribe from this list, please send an email to lists...@witango.com > > with "unsubscribe witango-talk" in the body. > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.