Len, yep, thats the right one. On Aug 15, 2011, at 9:36 AM, Mark Weiss wrote:
> 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. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.