Actually came up with a very simple vb macro:
endrange = Range(A65000).End(xlUp).Row
For r = 1 To endrange
If Range(A r).Value Like obj* Then
objgrp = Cells.Range(A r).Value
Else
netobj = Cells.Range(A r).Value
Range(H r).Value = objgrp netobj
End If
Next
From that I can make
Columns(3).SpecialCells(xlCellTypeBlanks).Delete
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Zeunasc
Sent: Tuesday, January 03, 2012 7:44 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Text manipulation
Actually came up with a very
Text manipulation is kind of difficult in VBA. I can be done. If you
have to do this in Excel. I would look at the regular expression
module. I would use a scripting tool like Python to preprocess and
put into csv or Excel.
Bill
On Jan 2, 3:11 pm, Zeunasc timothy.ry...@gmail.com wrote:
I
On Jan 2, 3:11 pm, Zeunasc timothy.ry...@gmail.com 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