[sids911]

Hello Everyone, Its my first post here :-)

I have a text file with values printed like these;

BSSID: 001E4ABXXXX
Last seen: 14/12/2011 - 16:06:12
Vendor: Cisco Systems
Signal: -91 dBm
SSID: NXXXX
Enc: OPEN
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 25
Unique WEP IVs: 0

BSSID: C03F0E3XXXXX
Last seen: 14/12/2011 - 15:57:27
Vendor: NETGEAR
Signal: -96 dBm
SSID: Misuss
Enc: WEP
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 6, 9, 12, 48, 18, 24, 36, 54,
Packets: 7
Unique WEP IVs: 0

BSSID: 001E4ABXXXXX
Last seen: 14/12/2011 - 15:56:49
Vendor: Cisco Systems
Signal: -95 dBm
SSID: Mobile
Enc: WPA2-CCMP-MGT
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 2
Unique WEP IVs: 0



I want to export this all to an excel spreadsheet with columns representing BSSID, Last Seen, vendor, Signal, SSID, Enc, Mode etc., and all the values belonging for an BSSID in a single row. Does it look doable? If yes, please let me know how to achieve this, and I will be highly obliged.

Much thanks!

Sid

[CoffeeFiend]

sids911, on 17 December 2011 - 05:11 AM, said:

Does it look doable?

Easily!

First, import the said txt file into excel. Now on another worksheet, use a simple formula like shown here to copy the data over. Don't worry, you only have to type the first cell, then you just drag the cell's corner handle thingy to fill in adjacent cells with it.

[sids911]

CoffeeFiend, on 17 December 2011 - 10:37 AM, said:

sids911, on 17 December 2011 - 05:11 AM, said:

Does it look doable?

Easily!

First, import the said txt file into excel. Now on another worksheet, use a simple formula like shown here to copy the data over. Don't worry, you only have to type the first cell, then you just drag the cell's corner handle thingy to fill in adjacent cells with it.

Much thanks!

I actually solved using a VBA macro script provided by a gentleman on another forum (since I had many files to convert). Not sure what the forum policies are, or else I would have linked to that thread.

please let me know if I should if it could help someone else.