Extracting Data from Putty Logs

Nintz

New Member
Joined
Jan 7, 2011
Messages
3
First I want to say thanks for anyone trying to help. I have not been successful at pulling this data thru scripting as easy as I think it should be its just not coming to me. Currently we run a program thru putty and it displays a series of number I have to validate against another list that is emailed to me. I would like to get this to pull the series and put them in a column for me. I have a vlookup and other things setup to show me what I need but getting this data takes way more steps then I want.

Here is the part of the log with the data I am referring to. The rest I don't really need.
Please remove the following 48 volume(s) from the MAP​
on media server cscsymapp06, robot TLD(0).​
Volumes: DB2008 TL2259 TL2321 TL2460 TL2501 TL2502 TL2730 TL2748 TL2750 TL2873 TL2888 TL3043 TL3045 TL3051 TL3084 TL3097 TL3191 TL3252 TL3323 TL3373 TL3498 TL3607 TL3646 TL3649 TL3699 TL3742 TL3813 TL3915 TL4141 TL4252 TL4392 TL4423 TL4436 TL4527 TL4567 TL4574 TL4613 TL4638 TL4661 TL4702 TL4706 TL4709 TL4758 TL4760 TL4761 TL4773 TL4777 TL4806​


Please remove the following 8 volume(s) from the MAP​
on media server cscsymapp06, robot TLD(0).​
Volumes: TL4826 TL4841 TL4861 TL4975 TL5000 TL5002 TL5050 TL5077​


Please remove the following 31 volume(s) from the MAP​
on media server cscsymapp06, robot TLD(0).​
Volumes: TL5107 TL5125 TL5129 TL5157 TL5171 TL5195 TL5222 TL6116 TL6118 TL6120 TL6122 TL6124 TL6125 TL6126 TL6128 TL6129 TL6132 TL6133 TL6135 TL6140 TL6142 TL6149 TL6151 TL6152 TL6153 TL6155 TL6156 TL6157 TL6160 TL6161 TL6162​


From this I need the DB and TL information in a single column. Currently I am just copy pasting, converting to columns then copying again and transposing. Any help would really be appreciated.

Thanks again.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Column1[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]DB2008[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL2259[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL2321[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL2460[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL2501[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL2502[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL2730[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL2748[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL2750[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL2873[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL2888[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3043[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3045[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3051[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3084[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3097[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3191[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3252[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3323[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3373[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3498[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3607[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3646[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3649[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3699[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3742[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL3813[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL3915[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4141[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4252[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4392[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4423[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4436[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4527[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4567[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4574[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4613[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4638[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4661[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4702[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4706[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4709[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4758[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4760[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4761[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4773[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4777[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4806[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4826[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4841[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL4861[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL4975[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL5002[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5050[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL5077[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5107[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL5125[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5129[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL5157[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5171[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL5195[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL5222[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6116[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6118[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6120[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6122[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6124[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6125[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6126[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6128[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6129[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6132[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6133[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6135[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6140[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6142[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6149[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6151[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6152[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6153[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6155[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6156[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6157[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6160[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TL6161[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]TL6162[/td][/tr]
[/table]


if this is ok, use PowerQuery aka Get&Transform
 
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,262
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top