Much as I agree with Colin's comments on simply REMOVEing the two values you want inside your loop, I can't help but think that Dave has some evil bad stuff he needs to do with the rest of IN.LINE that relies on the raised mark characters.
What I'd just like to point out though is that if there is a need to change characters in the string and especially in the 85000 item IN.TAB it would be considerably better to do that with CONVERT, RAISE(), or LOWER() than to use multiple SWAPs. CONVERT CHAR(9):CHAR(10) TO "" IN IN.TAB Will do it all in a single pass and also since CONVERT can never extend the string it can do the whole thing in place without a bunch of malloc()s. If you were going with the original idea of processing an attribute at a time and needed to work with @AM instead of @VM, you should use IN.LINE=RAISE(IN.LINE) instead of your SWAP statement because again this will be done in a single pass without the need for malloc()ing additional memory. KEN WALLIS * [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: Tuesday, 18 November 2008 7:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table That is what I was afraid of. Okay. So after listening to all of your comments (thus far since there is an annoying delay in these messages), here is what I like the best: SWAP CHAR(9) WITH "" IN IN.TAB SWAP CHAR(10) WITH "" IN IN.TAB SWAP @VM WITH CHAR(9) IN IN.TAB SWAP @SM WITH CHAR(10) IN IN.TAB REPEAT REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP CHAR(9) WITH @VM IN IN.LINE SWAP CHAR(10) WITH @SM IN IN.LINE (do my thing with IN.LINE) UNTIL MARK DO REPEAT Any objections, concerns or better suggestions for using CHAR(10) as the temporary substitute for the @SM? I just picked it because it came right after CHAR(9) on my handy-dandy ASCII chart! Been using it since the 70's. Some things just never go out of style! David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Delivering Products, Services, and Innovative Solutions" -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, November 17, 2008 2:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table If you don't want to 'swap' all the other markers with 'strings' (SWAP @VM WITH "<<VM>>" IN RECORD) then you have to 'build' the line item up -- keep removing until you see the remove hit the @AM and then process the line... DW > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma > Sent: Monday, November 17, 2008 1:24 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Speeding up processing through large dynamic table > > Oh my goodness! This is incredible. > > Okay, now I have a mixture of @VM and @AM in the table. The > REMOVE 'stops' at every @VM and @AM. I only want it to > 'stop' at @AMs. How do I do that? > > David Laansma > IT Manager > Hubbard Supply Co. > Direct: 810-342-7143 > Office:810-234-8681 > Fax: 810-234-6142 > www.hubbardsupply.com > "Delivering Products, Services, and Innovative Solutions" ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
