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 rajanichintan...@gmail.com
wrote:
On Jan 2, 3:11 pm, Zeunasc timothy.ry...@gmail.com wrote:
I need to compare the object-groups between two firewalls
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
if it doesn't.
On Oct 21, 6:59 pm, Haseeb Avarakkan haseeb.avarak...@gmail.com
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 is 40836 (40836 days after 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
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
)
On Tue, Oct 25, 2011 at 12:13 AM, Sam Mathai Chacko samde...@gmail.comwrote:
so if the line has a remark in it, then leave it as it is, otherwise,
remove anything that starts with (hitcnt or Ox?
Sam
On Tue, Oct 25, 2011 at 12:06 AM, Zeunasc timothy.ry...@gmail.com wrote:
My
this, or intelligently reuse any of the logic.
Thanks!!!
Z
On Oct 20, 8:15 pm, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Hello Zeunasc;
Try the attached.
Enter a start date in A2, End date in A4.
HTH
Haseeb
Parse_Text.xls
39KViewDownload
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 haseeb.avarak...@gmail.com
wrote:
Hello Zeunasc;
Try the attached
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 noorain.ans...@gmail.com wrote:
Dear Zeunasc,
Another Solution..
=SUBSTITUTE(A1,remark 10/19/2011, )
--
Thanks regards,
Noorain Ansari
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
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
11 matches
Mail list logo