Tim, It didn't "grow an extra comma" it just moved the one from infront to behind the word. That is where the problem lies. The Part Numbers (ones that consist of numbers and those that consist of words, i.e. "WIRE HARNESS") need to be the first column.
There are only a few PNs that consist of words. They are: - CAN HARNESS - CHOKE-BLACK - CHOKE-RED - MISC COAX AS - MISC HARNESS - PRICING HARNESS - PRICING PANEL - RELAY BOARD - START PAN.QUOTE - STUMP GRINDER RX - STUMP GRINDER TETHER - STUMPGRINDERTX - TEST PART - UPDATE KIT - WIRE HARNESS If I could figure out a way to get rid of everything except those it would work;-P Blake M. Sisco LOR Manufacturing Co., Inc Web Presence • Graphic Design www.lormfg.com (866) 644-8622 (888) 524-6292 FAX The information transmitted by Blake Sisco herewith is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer On Wed, Jul 15, 2009 at 9:24 AM, Tim Chase <[email protected]> wrote: > > > Before: > > *,WIRE HARNESS, > > ,20403,16 > > ,FIBERGLASS, > > ,100 FOOT, > > ,20400,7 > > ,FIBERGLASS, > > ,250 FOOT SPOOL, > > ,WX12-0,35 > > ,WX14-1BR/YLW,160 > > ,YELLOW STRIPE, > > ,87K 7267,16 > > ,SINGLE TWISTED PAIR SHIELDED, > > ,WITH DRAIN, > > ,32206,5 > > ,RING NON INS., > > ,DT06-3S,4 > > ,W3S,2 > > ,ORANGE, > > ,W3S-P012,2 > > ,GREEN, > > ,DT06-2S,2* > > > > After: > > *WIRE HARNESS,, > > ,20403,16 > > ,20400,7 > > ,WX12-0,35 > > ,WX14-1BR/YLW,160 > > ,87K 7267,16 > > ,32206,5 > > ,DT06-3S,4 > > ,W3S,2 > > ,W3S-P012,2 > > ,DT06-2S,2* > > While I'm not sure what transformation you *want* from this data, > the following turns your *before* into your *after* form: > > :g/^,.*[^,],$/d > > with the exception of the weirdness where the first "*WIRE > HARNESS," line grew an extra comma. > > -tim > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message from the "vim_use" maillist. For more information, visit http://www.vim.org/maillist.php -~----------~----~----~----~------~----~------~--~---
