As a follow up question, I have to do this review once a quarter, and the remark dates will change. How would I, programmatically, parse out the date string, then use that in an if/then... say, if this line contains a date between 10/01/2011 and 12/31/2011.
I know that the values are strings, so I could generate a text list of the dates, and use a "if this string exists in this list, then remove it, otherwise, leave it alone". On Oct 20, 4:23 am, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > Dear Zeunasc, > > Another Solution...... > =SUBSTITUTE(A1,"remark 10/19/2011"," ") > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > > > > > > > On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc <timothy.ry...@gmail.com> wrote: > > I know that this is relatively easy, but it has been years since I > > have done any Excel VBA. I am parsing out some firewall rules, and in > > order to compare lines, I need to remove a section of text from within > > a string. > > > The strings will look like this: > > > access-list BldA-I line 5 remark 10/19/2011 permit tcp host computer1 > > host computer2 eq 80 > > > I need to remove the section of text that reads "remark 10/19/2011". > > There could be 1000+ lines, so I need to be able to loop the code > > until there all of the remarks have been removed. > > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 -- ---------------------------------------------------------------------------------- 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
