If you're going to do it that way, I wouldn't bother with putting the @VMs back (or may the @SM's too, depending on what you're doing.
Get CUST.NUM and CUST.DESC from your modified IN.LINE as follows ... CUST.NUM = FIELD( IN.LINE, CHAR(9), 1, 1) CUST.DESC = FIELD( IN.LINE, CHAR(9), 1, 1) Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: 17 November 2008 20:19 To: [email protected] 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: [email protected] 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: [email protected] > 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- 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/
