Copied from help Single letters must always be enclosed in quotes in string operations so that they are treated as letters, and not as calculation variables. For example:
For more information, see beginswith. <@CALC EXPR="Henry beginswith 'H'"> evaluates the string "Henry" to see if it begins with the string "H" (case-insensitive). How about putting the "E" in quotes like this Original <@IFEQUAL "39149E20021231" "39006E20021231"> Problem </@IF> <@IFEQUAL "39149'E'20021231" "39006'E'20021231"> Problem </@IF> -----Original Message----- From: Kevin Quinn [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:59 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: When are these strings equal (Tango 2k) You could alternately use an @OMIT to remove the letters (if you know for a fact that there is only ever 1 letter in your string), or an @KEEP to keep all the numbers. -----Original Message----- From: Anthony M. Humphreys [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: When are these strings equal (Tango 2k) I was initially using the @IFEQUAL tag on these two strings, like so <@IFEQUAL '<@VAR aa>' '<@VAR bb>'> where aa = 39149E20021231 and where bb = 39006E20021231 so that it would be expanded out to this: <@IFEQUAL '39149E20021231' '39006E20021231'> and these two strings were always comparing true. I then translated this into an @CALC so that I could see if Tango really thought these two strings equal. So Kevin, are you telling me that any strings that have numbers and the letter "E" in them will be substituted with "2.718281828459045"? Or that the letter "G" in string will substituted with "0.381966011250105", etc? Wow, it DOES fail for G,E,L,P,Q,I,J,X also! These all fail to behave "predicatably"! <@CALC "39149G20021231"> <@CALC "39149E20021231"> <@CALC "39149L20021231"> <@CALC "39149P20021231"> <@CALC "39149Q20021231"> <@CALC "39149I20021231"> <@CALC "39149J20021231"> <@CALC "39149X20021231"> It's way too late to change the strings, and Tango does not have a text specific equality test method, like it does for "contains", "beginswith" and "endswith". So I guess I use always use JavaScript to do these comparisons going forward. What a pain! so now it's <@IF <@SCRIPT EXPR="if (server.getVariable('local$aa') == server.getVariable('local$bb')) {'1'; } else {'0';};">> which works predictably -----Original Message----- From: Kevin Quinn [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:39 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: When are these strings equal (Tango 2k) 'E' is a defined CALC variable. Unless you're planning on using natural logs, don't use E. Try a 'Z' or something. -----Original Message----- From: Anthony M. Humphreys [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:34 PM To: [EMAIL PROTECTED] Com (E-mail) Subject: Witango-Talk: When are these strings equal (Tango 2k) I was doing this comparison and it was True in Tango 2k!! <@CALC "'39149E20021231'='39006E20021231'"> In this particular data set the last eight characters are always equal anyways, so I was able to work around it by truncating the last eight chars in the comparison like so: <@CALC EXPR="'<@LEFT STR="39149E20021231" NUMCHARS="<@CALC 'len(39149E20021231) - 8'>">'='<@LEFT STR="39006E20021231" NUMCHARS="<@CALC 'len(39006E20021231) - 8'>">'"> But still, these two strings are NOT equal by any stretch of the imagination. Any one care to guess what Tango has done to compare these two strings equal? I'd hate to run into this one again! ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
