So does that mean that all your lines will always have the eq 80 in it? If not, can you attach a sample workbook with a few more examples that clearly depicts the possible list in your complete set of data.
Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 11:33 PM, Zeunasc <timothy.ry...@gmail.com> wrote: > You guys were such a help on the first part of this project, I thought > I would ask another question. The project I am working on is still a > review of firewall access-list lines. Quarterly, I have to review > their use and purge the ones that haven't been used. That said, the > output I get to review has 3 types of lines. One is a remark line, > one is the access list line, and the last is the exploded view of the > access list line: > > access-list BldA-I line 5 remark 10/19/2011 permit tcp host computer1 > host computer2 eq 80 > access-list BldA-I line 5 remark 10/19/2011 permit tcp host computer1 > host computer2 eq 80 0xa6f30e14 > access-list BldA-I line 5 remark 10/19/2011 permit tcp host computer1 > host computer2 eq 80 (hitcnt=39975) 0x11f2294d > > Basically, I will be dumping a couple of thousand lines of this kind > of text into column A of an Excel spreadsheet. The lines will always > be one of those 3 types, though there is no telling which types of > lines will appear where. The very first thing I need done is for the > "0xa6f30e14" (the string is unique per line, but is always 10 > characters long) and the "(hitcnt=39975) 0x11f2294d" (again, hitcnt > can be any number from 0 to infinity, so the length changes). > > Any help is appreciated! > Z > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel