View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] aiden_dar@yahoo.com is offline
external usenet poster
 
Posts: 1
Default TEXT and Data converted to only data

I am the sys administrator for a very big network. Each time one of
the computers is restarted on my network a small DOS batch file runs.
The first part of this DOS batch file updates a specific directory's
exe's with the newest versions from a shared network directory. The
second part of this batch file updates a central text file. I can then
check this text file to make sure that all the computers have been
updated on my network.

Here is an example of the text file: (TESTAAA.txt)

--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
THE DATE:
2007/03/01
-----------
THE TIME:
13:59
-----------
THE COMPUTER BEING SYNCHRONIZED:


Windows IP Configuration



Host Name . . . . . . . . . . . . : cpf8-wks

Primary Dns Suffix . . . . . . . : tantis.local

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : tantis.local



Ethernet adapter Local Area Connection:



Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Broadcom NetXtreme 57xx
Gigabit Controller

Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E

Dhcp Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 192.168.11.191

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.11.1

DHCP Class ID . . . . . . . . . . : Internet Users

DNS Servers . . . . . . . . . . . : 192.168.11.155

192.168.11.175

--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
THE DATE:
2007/03/01
-----------
THE TIME:
14:01
-----------
THE COMPUTER BEING SYNCHRONIZED:


Windows IP Configuration



Host Name . . . . . . . . . . . . : cpf1-wks

Primary Dns Suffix . . . . . . . : tantis.local

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : tantis.local



Ethernet adapter Local Area Connection:



Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Broadcom NetXtreme 57xx
Gigabit Controller

Physical Address. . . . . . . . . : 00-14-22-5F-25-E0

Dhcp Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 192.168.11.214

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.11.1

DNS Servers . . . . . . . . . . . : 192.168.11.155

192.168.11.175

--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
THE DATE:
2007/03/01
-----------
THE TIME:
15:19
-----------
THE COMPUTER BEING SYNCHRONIZED:


Windows IP Configuration



Host Name . . . . . . . . . . . . : cpf8-wks

Primary Dns Suffix . . . . . . . : tantis.local

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : tantis.local



Ethernet adapter Local Area Connection:



Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Broadcom NetXtreme 57xx
Gigabit Controller

Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E

Dhcp Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 192.168.11.191

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.11.1

DHCP Class ID . . . . . . . . . . : Internet Users

DNS Servers . . . . . . . . . . . : 192.168.11.155

192.168.11.175

--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
THE DATE:
2007/03/01
-----------
THE TIME:
15:19
-----------
THE COMPUTER BEING SYNCHRONIZED:


Windows IP Configuration



Host Name . . . . . . . . . . . . : cpf8-wks

Primary Dns Suffix . . . . . . . : tantis.local

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : tantis.local



Ethernet adapter Local Area Connection:



Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Broadcom NetXtreme 57xx
Gigabit Controller

Physical Address. . . . . . . . . : 00-14-22-5E-F2-4E

Dhcp Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 192.168.11.191

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.11.1

DHCP Class ID . . . . . . . . . . : Internet Users

DNS Servers . . . . . . . . . . . : 192.168.11.155

192.168.11.175

--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
THE DATE:
2007/03/01
-----------
THE TIME:
15:19
-----------
THE COMPUTER BEING SYNCHRONIZED:


Windows IP Configuration



Host Name . . . . . . . . . . . . : cpf3-wks

Primary Dns Suffix . . . . . . . : tantis.local

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : tantis.local



Ethernet adapter Local Area Connection:



Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Broadcom NetXtreme 57xx
Gigabit Controller

Physical Address. . . . . . . . . : 00-13-72-70-2F-25

Dhcp Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 192.168.11.196

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.11.1

DNS Servers . . . . . . . . . . . : 192.168.11.155

192.168.11.175





It is clear that the same information gets received from the computers
and gets repeated. My question is this: I would like to be able to get
only the critical information in table form.
For example:



Date Time IP Host Name
2007/03/01 13:59 192.168.11.1 cpf3-wks
2007/03/01 14:10 192.168.11.3 cpf7-wks
2007/03/01 14:30 192.168.11.18 cpf2-wks


If somebody can assist me in having a way to generate this report
automatically from a program I would be very very gratefull!!!

PLEASE HELP ME!!!
Thank you.