ue
Range("H" & r).Value = objgrp & netobj
End If
Next
>From that I can make two tables, one for each firewall, and use
vlookups to compare them.
Thank you for the help!
On Jan 2, 10:11 pm, computer tricks 1
wrote:
> On Jan 2, 3:11 pm, Zeunasc wrote:
>
>
>
>
I need to compare the object-groups between two firewalls for
differences. The raw data from the firewalls looks like this:
object-group network ABCDEF
network-object 1.1.1.0 255.255.248.0
network-object 2.2.2.0 255.255.254.0
object-group network GHIJKL
network-object host 3.3.3.3
network-obj
doesn't.
On Oct 21, 6:59 pm, Haseeb Avarakkan
wrote:
> Hello Zeunasc;
>
> I am not good in to explain something. Here is an attempt. Hope this would
> help you.
>
> A2 = Start Date, here 10/20/2011
>
> A4 = End Date, here 10/25/2011
>
> Basically 10/20/2011
",A1)),255,SEARCH("
> (h",A1)
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Tue, Oct 25, 2011 at 12:13 AM, Sam Mathai Chacko wrote:
>
>
>
>
>
>
>
>
>
> > so if the line has a remark in it, then leave it as it is, otherwise,
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 1
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
e this, or intelligently reuse any of the logic.
Thanks!!!
Z
On Oct 20, 8:15 pm, Haseeb Avarakkan
wrote:
> Hello Zeunasc;
>
> Try the attached.
>
> Enter a start date in A2, & End date in A4.
>
> HTH
> Haseeb
n I modify the
formula so that if the line falls outside of the date range, it just
returns a blank or empty cell, as opposed to returning the line in
tact?
Thank you so much for your help on this!
On Oct 20, 8:15 pm, Haseeb Avarakkan
wrote:
> Hello Zeunasc;
>
> Try the attached.
>
&
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 wrote:
> Dear Zeunasc,
>
> Another Solution..
> =SUBSTITUTE(A1,"remark 10/19/2011"
Both of these solutions work great... should have paid more attention
to the built in functions! Thank you both!
On Oct 20, 4:23 am, NOORAIN ANSARI wrote:
> Dear Zeunasc,
>
> Another Solution..
> =SUBSTITUTE(A1,"remark 10/19/2011"," ")
>
> --
> Th
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 p
11 matches
Mail list logo
