Again, the email timing issue. I was responding to the simple index with F200 not bounded. I've used bounding earlier and detected what you were doing.
Regarding the extra variable/effort by the SETTING and SET'd variable. I don't care for the argument of counting cycles. Granted, not wasting gross amounts of time is one thing. But who cares about the few alleged cycles that LOCATE would involve. That becomes a sticky debatable point that wastes more time talking about it than it actually does. Given today's extremely fast systems and the tame data requirements of any MV system, poorly written or not, we're not taxing the 4 CPU 3.0 Ghz servers as much as we think. Think about it. Today's RAM is hundreds of times larger than many of our earlier hard drives. Cycles, Schmycles. My 2 cents. Mark Johnson ----- Original Message ----- From: "Keith Johnson (DSLWN)" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, November 26, 2007 9:46 PM Subject: RE: [U2] Good Practice? > Hi Mark, > > Just a couple of points. > > First, the value of F200.SCHEME.CODE of CK *cannot* trigger a false > positive. > > TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' > IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE > > is fairly bulletproof because of the backslashes around both the string > and the substring. > > Second, I wasn't concerned about LOCATE adding a cycle or two. It's > just that one has to provide the SETTING variable which is then ignored. > INDEX involves a string, a substring, and a start count - there's > virtually nothing redundant. Using LOCATE involves a string, a > substring, the position found as well as (possibly) a start position and > a search sequence; so it can be regarded as a more complex function. > Also, one can choose from three forms of LOCATE - Pick, Ideal/Reality, > or Information. Then, to avoid the long setup string, one has to use > CONVERT (or SWAP or CHANGE). > > Regards, Keith > > PS Good surname - mine's Norwegian in origin... great grandad jumped > ship in Auckland. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
